|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Backing up DatabaseWhen I try to backup a SQL 2000 database I recieve the following error in
the output log. Any ideas? Thank you. SQL 2000 w/ SP4 [39] Database SolRounder: Database Backup... Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK] [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'G:\Backups\SolRounder\SolRounder_db_200704131221.BAK' failed, status = 112. See the SQL Server error log for more details. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. [40] Database SolRounderKids: Database Backup... Destination: [G:\Backups\SolRounderKids\SolRounderKids_db_200704131223.BAK] Gabe,
Error 112 is probably the Windows ERROR_DISK_FULL, which means that your G: drive does not have enough space to hold your backup file. See if you can clean up some things from the drive to give it more space. RLF Show quoteHide quote "Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message news:Oz8yowefHHA.4552@TK2MSFTNGP04.phx.gbl... > When I try to backup a SQL 2000 database I recieve the following error in > the output log. Any ideas? Thank you. > SQL 2000 w/ SP4 > > [39] Database SolRounder: Database Backup... > Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK] > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC > SQL Server Driver][SQL Server]Write on > 'G:\Backups\SolRounder\SolRounder_db_200704131221.BAK' failed, status = > 112. See the SQL Server error log for more details. > [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is > terminating abnormally. > [40] Database SolRounderKids: Database Backup... > Destination: > [G:\Backups\SolRounderKids\SolRounderKids_db_200704131223.BAK] > Working now. Thank you Russell!
Show quoteHide quote "Russell Fields" <russellfie***@nomail.com> wrote in message news:ueOlD4efHHA.4552@TK2MSFTNGP04.phx.gbl... > Gabe, > > Error 112 is probably the Windows ERROR_DISK_FULL, which means that your > G: drive does not have enough space to hold your backup file. > > See if you can clean up some things from the drive to give it more space. > > RLF > > "Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message > news:Oz8yowefHHA.4552@TK2MSFTNGP04.phx.gbl... >> When I try to backup a SQL 2000 database I recieve the following error in >> the output log. Any ideas? Thank you. >> SQL 2000 w/ SP4 >> >> [39] Database SolRounder: Database Backup... >> Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK] >> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC >> SQL Server Driver][SQL Server]Write on >> 'G:\Backups\SolRounder\SolRounder_db_200704131221.BAK' failed, status = >> 112. See the SQL Server error log for more details. >> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is >> terminating abnormally. >> [40] Database SolRounderKids: Database Backup... >> Destination: >> [G:\Backups\SolRounderKids\SolRounderKids_db_200704131223.BAK] >> > >  
Thread options
Other interesting topics
SQL Server 2005: Lock Escalation
Option (MAXDOP 1) Searching whole database cannot back up database to a disk file server maxing out processor TEXTIMAGE_ON database mirroring -- failing over in stored procedures Help with Reindexing all tables in a Database? SQL 2005 upgrade advisor's impact on the production server? Fulltext index and insert performance |
|||||||||||||||||||||||
