Re: Problems Backing Up
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/25/04
- Next message: Hassan: "Re: Can't see database in enterprise manager"
- Previous message: Hari Prasad: "Re: problem with starting SQL"
- In reply to: Dooza: "Re: Problems Backing Up"
- Next in thread: Hari Prasad: "Re: Problems Backing Up"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 25 Sep 2004 18:37:16 +0200
> Anyone have any ideas on this?
I'm afraid not. Many of us don't use the maintenance wizard because it is a layer on top of the SQL
commands, and when something goes wrong, you find it more difficult to hunt down the problem. As
this case seems, I find it difficult to provide more recommendation on the newsgroup. Consider
opening a case with MS Support and have them hunt down the problem...
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Dooza" <steve@whatareyoudooza.tv> wrote in message news:OtoBL6koEHA.2684@TK2MSFTNGP11.phx.gbl... > Hi Tibor, > I didnt have time last night to continue my exploration of the BACKUP > command, but I do have some odd news about the maintenance plan. Last night > the backup gave me this message: > > The file C:\MSSQL7\BACKUP\dmc\dmc_db_200409232100.BAK already exists. This > backup command is ignored > > It exists because I created a manual backup yesterday thinking that it would > make it work, seems I was wrong. So if the file isnt there it wont for some > reason create it, but it wont report that it hasnt either, but when the > verify runs it cant because the file isnt there, and thats when it reports > it missing. > > Anyone have any ideas on this? > > Cheers, > > Steve > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in > message news:eILB%23UXoEHA.1800@TK2MSFTNGP15.phx.gbl... >> Check out the BACKUP command. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Dooza" <steve@whatareyoudooza.tv> wrote in message > news:%23XVAY7WoEHA.3460@tk2msftngp13.phx.gbl... >> > Thats just it Tibor, when I do a manual backup in Enterprise Manager it >> > always works. I cant get it to fail, and I cant see a failure message, > the >> > only way I know it has failed is because the file it tries to verify > isnt >> > there. >> > >> > What is the SQL for backing up in QA? >> > >> > Steve >> > >> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote > in >> > message news:eKcoEgWoEHA.2068@TK2MSFTNGP09.phx.gbl... >> > > Can you reproduce this by executing all the BACKUP (and possibly > RESTORE) >> > commands from QA? If so, >> > > can you post those commands here? >> > > >> > > -- >> > > Tibor Karaszi, SQL Server MVP >> > > http://www.karaszi.com/sqlserver/default.asp >> > > http://www.solidqualitylearning.com/ >> > > >> > > >> > > "Dooza" <steve@whatareyoudooza.tv> wrote in message >> > news:e3%23LzbWoEHA.1308@TK2MSFTNGP14.phx.gbl... >> > > > Hi Tibor, >> > > > I dont currently have anti-virus on this server, so it cant be that. > The >> > > > problem is that the backup file isnt being genereated, and for some >> > reason >> > > > SQL thinks it has, so when it goes to verify its not there. >> > > > >> > > > Thanks for all your help, I am sure there must be a simple answer to >> > this. >> > > > >> > > > Steve >> > > > >> > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> > wrote >> > in >> > > > message news:%23EuPvVWoEHA.3792@TK2MSFTNGP11.phx.gbl... >> > > > > My guess is that the verify fail because of some other process is >> > using >> > > > the file. Probably some >> > > > > anti-virus process. Also, the VERIFY option isn't exactly what is >> > sounds >> > > > like. I suggest you read >> > > > > about it in Books Online... >> > > > > >> > > > > -- >> > > > > Tibor Karaszi, SQL Server MVP >> > > > > http://www.karaszi.com/sqlserver/default.asp >> > > > > http://www.solidqualitylearning.com/ >> > > > > >> > > > > >> > > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message >> > > > news:%23n29qlVoEHA.2920@TK2MSFTNGP10.phx.gbl... >> > > > > > Hi Tibor, >> > > > > > Ok that makes sense. >> > > > > > >> > > > > > This morning I did a manual backup, the filename I used is >> > > > > > \dmc_db_200409232100.BAK. I then did this in QA: RESTORE > VERIFYONLY >> > FROM >> > > > > > DISK = >> > > > > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409232100.BAK' >> > > > > > >> > > > > > And it returned: The backup set is valid. >> > > > > > >> > > > > > Why can I manually backup and verify yet it cant? >> > > > > > >> > > > > > My daily backup backsup 3 databases, 2 fail on the verify. I > also >> > have a >> > > > > > weekly backup for other databases, some of the larger ones also > fail >> > on >> > > > the >> > > > > > verify. This really needs to be rectified, so any help to solve > this >> > > > would >> > > > > > be great. >> > > > > > >> > > > > > Steve >> > > > > > >> > > > > > "Tibor Karaszi" > <tibor_please.no.email_karaszi@hotmail.nomail.com> >> > wrote >> > > > in >> > > > > > message news:eAz3xTVoEHA.1272@TK2MSFTNGP09.phx.gbl... >> > > > > > > > Can >> > > > > > > > anyone explain how the file is named? Whats the 2100 all > about >> > at >> > > > the >> > > > > > end? >> > > > > > > >> > > > > > > Year, date and time: >> > > > > > > YYYYMMDDhhmm >> > > > > > > >> > > > > > > -- >> > > > > > > Tibor Karaszi, SQL Server MVP >> > > > > > > http://www.karaszi.com/sqlserver/default.asp >> > > > > > > http://www.solidqualitylearning.com/ >> > > > > > > >> > > > > > > >> > > > > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message >> > > > > > news:u9LBrCVoEHA.896@TK2MSFTNGP12.phx.gbl... >> > > > > > > > Still didnt work. This is what happened: >> > > > > > > > >> > > > > > > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: >> > > > [Microsoft][ODBC >> > > > > > SQL >> > > > > > > > Server Driver][SQL Server]Cannot open backup device >> > > > > > > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409222100.BAK'. Device error > or >> > > > device >> > > > > > > > off-line. See the SQL Server error log for more details. >> > > > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or > restore >> > > > > > operation >> > > > > > > > terminating abnormally. >> > > > > > > > >> > > > > > > > But then I am not surprised as the filename its expecting > doesnt >> > > > exist. >> > > > > > Can >> > > > > > > > anyone explain how the file is named? Whats the 2100 all > about >> > at >> > > > the >> > > > > > end? >> > > > > > > > >> > > > > > > > Steve >> > > > > > > > >> > > > > > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message >> > > > > > > > news:O9iiHFMoEHA.868@TK2MSFTNGP10.phx.gbl... >> > > > > > > > > Hi Tibor, >> > > > > > > > > After googling I found that it was because I was adding a >> > second >> > > > file >> > > > > > to >> > > > > > > > the >> > > > > > > > > backup media set, once I had removed the first file it > would >> > let >> > > > me >> > > > > > backup >> > > > > > > > > the database. I created the file with todays date, so > tonight >> > I >> > > > will >> > > > > > see >> > > > > > > > if >> > > > > > > > > the backup set works succesfully and verifies too. >> > > > > > > > > >> > > > > > > > > Steve >> > > > > > > > > >> > > > > > > > > "Tibor Karaszi" >> > <tibor_please.no.email_karaszi@hotmail.nomail.com> >> > > > > > wrote >> > > > > > > > in >> > > > > > > > > message news:eKMGLCMoEHA.708@TK2MSFTNGP09.phx.gbl... >> > > > > > > > > > The message states that you have tried to perform a > striped >> > > > backup >> > > > > > > > against >> > > > > > > > > this file. Use what the >> > > > > > > > > > error say, add the FORMAT option to the backup command, > this >> > > > will >> > > > > > remove >> > > > > > > > > this striping information >> > > > > > > > > > and let you use the file as a single backup file again. >> > > > > > > > > > >> > > > > > > > > > -- >> > > > > > > > > > Tibor Karaszi, SQL Server MVP >> > > > > > > > > > http://www.karaszi.com/sqlserver/default.asp >> > > > > > > > > > http://www.solidqualitylearning.com/ >> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message >> > > > > > > > > news:%23Bh9W7LoEHA.800@TK2MSFTNGP14.phx.gbl... >> > > > > > > > > > >I just tried to do a manual backup from Enterprise > Manager, >> > and >> > > > > > this >> > > > > > > > time >> > > > > > > > > I >> > > > > > > > > > > tried to add a new backup destination but when I ran > the >> > > > backup I >> > > > > > got >> > > > > > > > > this >> > > > > > > > > > > error: >> > > > > > > > > > > >> > > > > > > > > > > The colume on decive >> > > > > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200402230200.BAK' is >> > > > > > > > > not >> > > > > > > > > > > part of a multifamily (RAID) media set. Use WITH > FORMAT to >> > > > form a >> > > > > > new >> > > > > > > > > RAID >> > > > > > > > > > > set. Backup or restore operation terminating > abnormally. >> > > > > > > > > > > >> > > > > > > > > > > The server does have a RAID array and the C: drive is >> > > > formatted >> > > > > > > > > correctly. >> > > > > > > > > > > What does this error mean? >> > > > > > > > > > > >> > > > > > > > > > > Steve >> > > > > > > > > > > >> > > > > > > > > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message >> > > > > > > > > > > news:%23ShRMzLoEHA.2684@TK2MSFTNGP11.phx.gbl... >> > > > > > > > > > >> Hi Hari, >> > > > > > > > > > >> For some reason the database backup file isnt being >> > created >> > > > even >> > > > > > tho >> > > > > > > > it >> > > > > > > > > > >> shows the backup as succesful. It reports that it > took 33 >> > > > seconds >> > > > > > to >> > > > > > > > > > > backup >> > > > > > > > > > >> the database which is over 900Mb in size! Any ideas > why >> > it >> > > > > > wouldnt >> > > > > > > > > create >> > > > > > > > > > >> the backup file and not report the error? >> > > > > > > > > > >> >> > > > > > > > > > >> Steve >> > > > > > > > > > >> >> > > > > > > > > > >> "Hari Prasad" <HariPrasad@discussions.microsoft.com> >> > wrote in >> > > > > > message >> > > > > > > > > > >> >> > news:F6A0B1B1-73C9-4DF5-8F1F-EBB0A984E444@microsoft.com... >> > > > > > > > > > >> > Hi, >> > > > > > > > > > >> > >> > > > > > > > > > >> > The issue normally comes incase if the backup file > is >> > not >> > > > > > available >> > > > > > > > > or >> > > > > > > > > > >> locked. >> > > > > > > > > > >> > I have faced this type of errors because of > antivirus >> > > > software >> > > > > > ? >> > > > > > > > > > >> > By turning off the checks in SQL Server folders > problem >> > was >> > > > > > solved. >> > > > > > > > > > >> > Other probabily might be some scheduled jobs tring > to >> > copy >> > > > the >> > > > > > file >> > > > > > > > > to a >> > > > > > > > > > >> > different location. Check this as well. >> > > > > > > > > > >> > >> > > > > > > > > > >> > As peter sugegsted execute the Verifyonly option as >> > well. >> > > > > > > > > > >> > >> > > > > > > > > > >> > Thanks >> > > > > > > > > > >> > Hari >> > > > > > > > > > >> > MCDBA >> > > > > > > > > > >> > >> > > > > > > > > > >> > >> > > > > > > > > > >> > "Dooza" wrote: >> > > > > > > > > > >> > >> > > > > > > > > > >> > > Hi there, >> > > > > > > > > > >> > > I have a daily backup running in SQL7 Server, and > it >> > > > > > completes >> > > > > > > > the >> > > > > > > > > > >> backup, >> > > > > > > > > > >> > > but fails on the Verification. These are the > error >> > logs I >> > > > am >> > > > > > > > > getting. >> > > > > > > > > > >> Surely >> > > > > > > > > > >> > > it should create the backup file if it cant find > it? >> > Can >> > > > > > anyone >> > > > > > > > > give >> > > > > > > > > > > me >> > > > > > > > > > >> some >> > > > > > > > > > >> > > help? >> > > > > > > > > > >> > > >> > > > > > > > > > >> > > Steve >> > > > > > > > > > >> > > >> > > > > > > > > > >> > > 2004-09-20 23:00:43.67 kernel >> > > > BackupDiskFile::OpenMedia: >> > > > > > Backup >> > > > > > > > > > > device >> > > > > > > > > > >> > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409202300.BAK' > failed >> > to >> > > > > > open. >> > > > > > > > > > > Operating >> > > > > > > > > > >> > > system error = 2(The system cannot find the file >> > > > specified.). >> > > > > > > > > > >> > > 2004-09-20 23:00:50.96 kernel >> > > > BackupDiskFile::OpenMedia: >> > > > > > Backup >> > > > > > > > > > > device >> > > > > > > > > > >> > > > 'C:\MSSQL7\BACKUP\forums\forums_db_200409202300.BAK' >> > > > failed >> > > > > > to >> > > > > > > > > open. >> > > > > > > > > > >> > > Operating system error = 2(The system cannot find > the >> > > > file >> > > > > > > > > > > specified.). >> > > > > > > > > > >> > > 2004-09-20 23:00:57.21 backup Database backed > up >> > with >> > > > > > following >> > > > > > > > > > >> > > information: Database: store, creation date and > time: >> > > > > > > > > > >> 2001/04/12(10:59:40), >> > > > > > > > > > >> > > pages dumped: 1958, first LSN: 1374:290:10, last > LSN: >> > > > > > 1374:294:1, >> > > > > > > > > sort >> > > > > > > > > > >> > > order: 52, striped: 0, number of dump devices: 1, >> > device >> > > > > > > > > information: >> > > > > > > > > > >> > > (FILE=1, TYPE=DISK: >> > > > > > > > > > >> > {'C:\MSSQL7\BACKUP\store\store_db_200409202300.BAK'}). >> > > > > > > > > > >> > > 2004-09-21 00:00:20.09 kernel >> > > > BackupDiskFile::OpenMedia: >> > > > > > Backup >> > > > > > > > > > > device >> > > > > > > > > > >> > > >> > 'C:\MSSQL7\BACKUP\forums\forums_tlog_200409210000.TRN' >> > > > failed >> > > > > > to >> > > > > > > > > open. >> > > > > > > > > > >> > > Operating system error = 2(The system cannot find > the >> > > > file >> > > > > > > > > > > specified.). >> > > > > > > > > > >> > > 2004-09-21 00:00:21.45 backup Log backed up > with >> > > > following >> > > > > > > > > > >> information: >> > > > > > > > > > >> > > Database: store, creation date and time: >> > > > > > 2001/04/12(10:59:40), >> > > > > > > > > first >> > > > > > > > > > >> LSN: >> > > > > > > > > > >> > > 1373:482:1, last LSN: 1374:301:1, striped: 0, > number >> > of >> > > > dump >> > > > > > > > > devices: >> > > > > > > > > > > 1, >> > > > > > > > > > >> > > device information: (FILE=1, TYPE=DISK: >> > > > > > > > > > >> > > >> > {'C:\MSSQL7\BACKUP\store\store_tlog_200409210000.TRN'}). >> > > > > > > > > > >> > > 2004-09-21 23:00:44.56 kernel >> > > > BackupDiskFile::OpenMedia: >> > > > > > Backup >> > > > > > > > > > > device >> > > > > > > > > > >> > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409212300.BAK' > failed >> > to >> > > > > > open. >> > > > > > > > > > > Operating >> > > > > > > > > > >> > > system error = 2(The system cannot find the file >> > > > specified.). >> > > > > > > > > > >> > > 2004-09-21 23:00:53.51 kernel >> > > > BackupDiskFile::OpenMedia: >> > > > > > Backup >> > > > > > > > > > > device >> > > > > > > > > > >> > > > 'C:\MSSQL7\BACKUP\forums\forums_db_200409212300.BAK' >> > > > failed >> > > > > > to >> > > > > > > > > open. >> > > > > > > > > > >> > > Operating system error = 2(The system cannot find > the >> > > > file >> > > > > > > > > > > specified.). >> > > > > > > > > > >> > > 2004-09-21 23:00:59.92 kernel >> > > > BackupDiskFile::OpenMedia: >> > > > > > Backup >> > > > > > > > > > > device >> > > > > > > > > > >> > > > 'C:\MSSQL7\BACKUP\store\store_db_200409212300.BAK' >> > failed >> > > > to >> > > > > > > > open. >> > > > > > > > > > >> Operating >> > > > > > > > > > >> > > system error = 2(The system cannot find the file >> > > > specified.). >> > > > > > > > > > >> > > 2004-09-22 00:00:15.93 kernel >> > > > BackupDiskFile::OpenMedia: >> > > > > > Backup >> > > > > > > > > > > device >> > > > > > > > > > >> > > >> > 'C:\MSSQL7\BACKUP\forums\forums_tlog_200409220000.TRN' >> > > > failed >> > > > > > to >> > > > > > > > > open. >> > > > > > > > > > >> > > Operating system error = 2(The system cannot find > the >> > > > file >> > > > > > > > > > > specified.). >> > > > > > > > > > >> > > >> > > > > > > > > > >> > > >> > > > > > > > > > >> > > >> > > > > > > > > > >> >> > > > > > > > > > >> >> > > > > > > > > > > >> > > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > > >> > > > > > > >> > > > > > > >> > > > > > >> > > > > > >> > > > > >> > > > > >> > > > >> > > > >> > > >> > > >> > >> > >> >> > >
- Next message: Hassan: "Re: Can't see database in enterprise manager"
- Previous message: Hari Prasad: "Re: problem with starting SQL"
- In reply to: Dooza: "Re: Problems Backing Up"
- Next in thread: Hari Prasad: "Re: Problems Backing Up"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
