You can issue an 'alter tablespace {tablespace name} end backup;’ in sqlplus. To verify the file is out of the backup mode, you can issue ‘select FILE#,STATUS from V$backup;’ (all the files should be ‘not active’)
Unfortunately just stopping the Symantec Antivirus Service might not be enough, because it is considered a device driver, you might need to temporarily disable it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;816071
Instead of purchasing a license for the SQL Agent, here is what we are doing to backup our MSDE database:
Create a Scheduled Task using the path to osql.exe like so:
F:\MSSQL7\Binn\osql.exe -Usa -P -i f:\mssql7\jobs\BESMgmt.cmd
And the BESMgmt.cmd contains the following: (replace the BESMgmt...
PulsaMatt, couple of things:
1)Did you run the post Arcserve SP5 Device update - supposedly fixes a lot of tape drive issues
2)We have seen this error alot due to faulty or bad tapes - the DLT and especially SDLT tape drives are sensitive, if the litres (sp?) go bad on the tape it affects the...
I just became reponsible for a Backup Exec 8.5 (Rev. 3571) server with an HP C7200-8000 Library attached to it. The C7200 has a bad tape drive which has been disabled.
My question is every time I fill the slots up with tapes and run an inventory it labels the tapes as (Cleaning Media) and the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.