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 |
|
Musa_Naz20
Starting Member
1 Post |
 Posted - 2008-01-21 : 06:23:47
|
| I am new to this site. I am facing problem while taking backup.I am trying to take backup through Enterprise manager to a particular folder. This error msg pops.---------------------------Microsoft SQL-DMO (ODBC SQLState: 42000)---------------------------Cannot open backup device 'C:\demo'. Device error or device off-line. See the SQL Server error log for more details.BACKUP DATABASE is terminating abnormally.---------------------------OK ---------------------------Thanks in AdvanceThank UJM |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-21 : 10:09:41
|
| check thats valid path and service account has permission to access it |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-01-21 : 11:07:05
|
| If C:\Demo is a folder, then you need to specify a file name (usually something.bak). |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 16:11:15
|
| Where is 'C:\demo'? On sql server or your pc? |
|
|
|
|
|
|
Database Back Problem