Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noob_aug11
Starting Member
5 Posts |
 Posted - 2011-08-30 : 19:43:35
|
| I did a script transfer of the backup job and the code as BACKUP DATABASE db1 TO [db1] ...So my question is where's [db1]?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-30 : 21:33:44
|
| http://msdn.microsoft.com/en-us/library/ms187932.aspx |
 |
|
|
noob_aug11
Starting Member
5 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-30 : 22:18:55
|
| You can query sysdevices. See link above |
|
|
|
noob_aug11
Starting Member
5 Posts |
Posted - 2011-08-31 : 11:02:39
|
quote:
Originally posted by russell
You can query sysdevices. See link above
ahhh .. thank you so much. it is in the sys.sysdevices. Or for future extreme noob, it'll be under Server Objects in SQL Server Management Studio as well. |
|
|
|
|
|
|
Where's the backup file?