kevinsql7 (9/3/2009)
Sarabpreet,Thanks for your response. I have two questions; what do you mean when you say:
1. Disable the log backup on prod.
My DB size is around 800 GBs and our Diff. backup takes 2-3hrs time to complete that too with the help of Red-Gate, now during this time our log backup has to wait and just to avoid this i disable the job. (I think if any backup is running on a DB you can't run any other backup on the same DB)
I am taking a nightly full database backup and log file backup even though we are not using the log backups to retore. So, basically, I have a full database backup.
So in your case you don't have to worry about this.
Also, what do you mean when you say to restore the database using a query.
6. Restore the DB using a predefined query since the name of the backup file is still pre-defined.
Steve is right, i was refering to RESTORE Command....My mistake:rolleyes:
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek