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 |
|
pssheba
Yak Posting Veteran
95 Posts |
 Posted - 2007-10-02 : 05:18:01
|
Hi everyone,I downloaded code for backup from BOL and MSDN to create Backup. It goes this way:USE fiftyplusGOBACKUP DATABASE fiftyplusTO DISK = 'C:\' WITH NAME = 'Full Backup of AdventureWorks'GO Instead of backup i get the following error message: quote:
Server: Msg 3201, Level 16, State 1, Line 1Cannot open backup device 'C:\'. Device error or device off-line. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.
Why is that? Can anyone help me with that please ?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-02 : 07:56:06
|
| The DISK = 'C:\'is on the server where the database is running (i.e. not on your local C: drive)Perhaps the server does not have a C: drive?Kristen |
 |
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2007-10-02 : 09:11:46
|
| Hi Kristen,I tried all other alphabetic letters and the same error appearedThanks |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-02 : 09:32:53
|
| I've never used the WITH NAME part, but don't you have to give it a name where DISK=?. Like DISK = 'C:\somebackup.bak'? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-02 : 09:50:54
|
| Yes, the DISK parameter must be a full path and filenameKristen |
|
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2007-10-02 : 10:57:42
|
quote:
Originally posted by Van
I've never used the WITH NAME part, but don't you have to give it a name where DISK=?. Like DISK = 'C:\somebackup.bak'?
oops, now it works...Thank you so much fellows |
|
|
|
|
|
|
backup database-error message