April 18, 2006 at 7:06 pm
I would Like to Have a Script or Stored Procedure that performs a
Backup of One Particular Database and after completion of backup it must do the verification whether it is corrupted or not.
If any problem arrises it must stop the process.
Can any one help in this Case.
I know how to do the backup of database through script
Example :-
first of all we need to add device..
next
BACKUP DATABASE Validator TO MyNwind_2
fine its working but how to check that the database is correctly backuped
with out any errors.
Can any body help in this regard
April 19, 2006 at 2:01 am
Try RESTORE VERIFYONLY FROM
April 19, 2006 at 6:13 pm
Thanks for reply david.poole
But is it posssible that taking a full database backup from the front application is suggested way or not.
Actually The client has specified to take a full database backup from the application.
Is is suggesstable or recommended ?
Since the database size grows day by day , so if we see this situation most of the idle time is taken by the database backup only.
Can you suggest in this case
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply