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 |
|
bloveday
Starting Member
2 Posts |
 Posted - 2010-06-03 : 15:48:06
|
| HiThis is probably a very simple thing, but I cant find the answer with Google.I am trying to script a backup job in SQL on a named instance.The commands I run are:backup database [tcr] to disk='Network Path\Automatic Backups\Tcr-DB.bak'with formatBut I get an error message:Msg 911, Level 16, State 11, Line 1Could not locate entry in sysdatabases for database 'tcr'. No entry found with that name. Make sure that the name is entered correctly.Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.When i run this command on the default instance to all my other databases it works fine.Any ideas?Thanks,Brett |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bloveday
Starting Member
2 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Backup command to named instance