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 |
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-27 : 05:48:45
|
Dear Experts,My Full Database backup job fails with the below message in the log.Please help me.Executed as user: xxxx\SQLService. Device dropped. [SQLSTATE 01000] (Message 15463) 17 percent processed. [SQLSTATE 01000] (Message 3211) 26 percent processed. [SQLSTATE 01000] (Message 3211) 34 percent processed. [SQLSTATE 01000] (Message 3211) 43 percent processed. [SQLSTATE 01000] (Message 3211) 52 percent processed. [SQLSTATE 01000] (Message 3211) 60 percent processed. [SQLSTATE 01000] (Message 3211) 78 percent processed. [SQLSTATE 01000] (Message 3211) 86 percent processed. [SQLSTATE 01000] (Message 3211) 95 percent processed. [SQLSTATE 01000] (Message 3211) Processed 1472 pages for database 'Admin', file 'Admin' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent processed. [SQLSTATE 01000] (Message 3211) Processed 3 pages for database 'Admin', file 'Admin_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 1475 pages in 0.641 seconds (17.966 MB/sec). [SQLSTATE 01000] (Message 3014) Device dropped. [SQLSTATE 01000] (Message 15463) 11 percent processed. [SQLSTATE 01000] (Message 3211) 20 percent processed. [SQLSTATE 01000] (Message 3211) 32 percent processed. [SQLSTATE 01000] (Message 3211) 41 percent processed. [SQLSTATE 01000] (Message 3211) 50 percent processed. [SQLSTATE 01000] (Message 3211) 62 percent processed. [SQLSTATE 01000] (Message 3211) 71 percent processed. [SQLSTATE 01000] (Message 3211) 82 percent processed. [SQLSTATE 01000] (Message 3211) 92 percent processed. [SQLSTATE 01000] (Message 3211) Processed 4320 pages for database 'BudgetManager', file 'BudgetManager_dat' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent processed. [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'BudgetManager', file 'BudgetManager_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 4321 pages in 1.268 seconds (26.622 MB/sec). [SQLSTATE 01000] (Message 3014) Device dropped. [SQLSTATE 01000] (Message 15463) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013) The log for database 'CompanyReference' is not available. Check the event log for related error messages. Resolve any errors and restart the database. [SQLSTATE HY000] (Error 9001). The step failed.Thanks,Javeed. |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2013-03-27 : 06:26:24
|
Have you taken CompanyReference offline or is it in a state other than available? |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-27 : 08:16:57
|
the only thing diffrent on companyreference database compared to others is 'autoclose' option is enabled on it.Is that making this issue? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-03-27 : 12:04:48
|
probably.AutoClose should never be enabled. Make sure it's online when the backup runs. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-04-01 : 02:37:16
|
Thanks Russel.After disabling the auto close property,the job is now running fine.mohammad.javeed.ahmed@gmail.com |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-01 : 18:52:03
|
Welcome. Glad to hear it. |
|
|
|
|
|