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 |
|
Revuca
Starting Member
19 Posts |
 Posted - 2003-01-07 : 05:42:00
|
| Hi,I scheduled and ran a few backups to a network drive using a backup device.All work fine apart from the largest db (10 GB) which runs for about 4 hoursand according to the log completed successfully.The .bak files also seems to have been written successfully so I assume the backup was successful, but there are 2x processes in 'Current activity' which reference the master db (the other has no db context) which relate to the backup that probably should not be there ?Status : runnableCommand : RESTORE HEADERONApplication : SQL Agent (T-SQL Jobstep xxxxxxx)I enabled an email option to notify me of the status when complete. I did not receive an email.I'd be grateful if anybody can shed any light on this for me.Thanks.Mike |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-07 : 07:18:04
|
| All work fine apart from the largest db (10 GB) which runs for about 4 hours and according to the log completed successfully.Don't rely on this - the only way to tell if a backup is ok is to restore it which you should do periodically for all databases.I copy the backups to another server and restore them and run dbcc checks automatically every day.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Revuca
Starting Member
19 Posts |
Posted - 2003-01-07 : 10:43:44
|
| Thanks nr. Yes I would need to verify this and your suggestions sound like the best way to do it. Any idea what the processes mean though ? |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2003-01-07 : 12:17:43
|
| SQL does not let go of the threads so easy.Further, make sure your "SQL Server Agent" is up and running for you to receive such messages. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-07 : 12:35:49
|
| Have you used the e-mail function before for a job? If not, SQL Mail is probably not configured, so that's why you didn't receive an e-mail. If you have e-mailed before from SQL Server, then the backup probably isn't complete. Try copying the .bak file somewhere else and see if you get an error. If the file is in use, the backup is still occurring. |
|
|
|
gwhiz
Yak Posting Veteran
78 Posts |
Posted - 2003-01-07 : 13:38:23
|
| Did you set this up using the maintenance wizard and set it up to verify the backup. This looks like the job is not finished the backup has completed but the verify is still running. |
|
|
|
Revuca
Starting Member
19 Posts |
Posted - 2003-01-08 : 05:25:23
|
| To answer the last few responses:Yes, I have received email before.I didn't backup through the maintenance wizard, but did select verification. According to the job history it did complete successfully - backup part of it, but states that email was unsuccessful.Can anyone shed any light on what HEADERON may mean ?Thanks |
|
|
|
|
|
|
Backup complete ?