| Author |
Topic |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2002-04-16 : 02:37:45
|
| I am facing a strange problem.I have scheduled a backup at 12 midnight.Every time it overwrites the current one.The problem is that the size of the scheduled back is 5 times that of the backup taken manually. Why?Also when i tried to restore the database from scheduled back it is not restoring the full database.why?Thanx in advance---------------------------Sandesh - The Messanger |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2002-04-16 : 03:39:43
|
Check whether u have checked differentical backup.quote:
I am facing a strange problem.I have scheduled a backup at 12 midnight.Every time it overwrites the current one.The problem is that the size of the scheduled back is 5 times that of the backup taken manually. Why?Also when i tried to restore the database from scheduled back it is not restoring the full database.why?Thanx in advance---------------------------Sandesh - The Messanger
|
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-16 : 03:44:21
|
| No,I have not checked differential backup...its full back up---------------------------Sandesh - The Messanger |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-16 : 09:42:05
|
| Are you appending the scheduled backup to the same backup file each time. Check the options and make sure you're using the WITH INIT backup paramater.Jeff BanschbachConsultant, MCDBA |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-17 : 01:09:52
|
| I am over writting the same back up file each time.---------------------------Sandesh - The Messanger |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-04-17 : 08:17:30
|
| I hate to overwrite, and I personally would prefer deleting over overwriting. I wrote a stored procedure that will shell out to a VB app and delete the old backup and then wrote the code to perform the backup. Then I just create a job to call the stored procedure. No problems with this method, unfortuneatly you have to introduce VB into it. Instead of my VB program though, you could shell out to the del command to delete the file.*************************Just trying to get things done |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-17 : 08:24:54
|
| Roy,But it really affects the size of Bak file?also it is not restoring properly---------------------------Sandesh - The Messanger |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-17 : 08:28:07
|
quote:
I hate to overwrite, and I personally would prefer deleting over overwriting. I wrote a stored procedure that will shell out to a VB app and delete the old backup and then wrote the code to perform the backup.
UUUUUUUUUGGGGGGGGGGGGGGGHHHHHHHHHHHHH!I hope you're alternating the files/devices you're backing up to when you delete a file; what happens if you delete the backup file and the backup op fails, and your server dies? I can't see any way for SQL Server to recover if there is a problem of some kind. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-04-17 : 08:34:39
|
| yes, i think this will be the dangerous solution.---------------------------Sandesh - The Messanger |
|
|
|
|
Scheduled Backup Size