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 |
|
jeer
Starting Member
32 Posts |
 Posted - 2008-04-09 : 23:45:32
|
| hiwhen i give the query (backup database to disk = 'c:\bk.bak') for backup, i got the error that device not found. please guide me to resolve this.regards |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 00:00:09
|
| Did you put your databasename in query |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-10 : 00:00:32
|
| You need to specify the database name.BACKUP DATABASE dbNameGoesHereTO DISK = 'C:\bk.bak'Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 00:02:30
|
Tara,Can you put that technical echo picture? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-10 : 00:03:20
|
| I typically delete my post if someone beat me in replying, but since mine has more info, I'll leave it there.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 00:04:59
|
| Agreed Tara |
|
|
|
|
|
|
backup