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 |
|
naya
Starting Member
2 Posts |
 Posted - 2006-11-14 : 09:18:45
|
| Hi, I am getting following errors while trying to back up a database. I am selecting a different location where my backups should be stored ('I:\'), but in the error I am seeing a different location ('G:\'). Could someone expalin me why there is a change in location and how to get rid of these errors.3041 : BACKUP failed to complete the command BACKUP DATABASE [coeforum] TO DISK = N'G:\dbbackup2\coeforum_db_200611140200.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 18204 : BackupDiskFile::CreateMedia: Backup device 'G:\dbbackup2\coeforum_db_200611140200.BAK' failed to create. Operating system error = 3(The system cannot find the path specified.). |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-14 : 09:49:50
|
| What is the Backup command that you are using?Kristen |
 |
|
|
naya
Starting Member
2 Posts |
Posted - 2006-11-14 : 10:36:47
|
Kristen,I am using SQL server enterprise manager to do the backup. I'm following this procedure: right click on database> select all tasks> select backup database> and then selecting a location for backup file and so on. Is this not the way we do backups?quote:
Originally posted by Kristen
What is the Backup command that you are using?Kristen
|
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-14 : 10:45:22
|
| "Is this not the way we do backups?"Its a way!BACKUP DATABASE MyDatabaseName TO DISK = 'x:\MyPath\MyFilename.BAK'WITH INIT, STATS = 10is another - and more likely to show you what is going wrong.Kristen |
|
|
|
|
|
|
Database backup error