September 16, 2009 at 12:17 am
suppose adatabase is there. we backuped that database,if the backup is failed due to some reasons what should we do
September 16, 2009 at 12:53 am
find out the reason why the backup failed? Take another backup. Backup is very much necessary to bring up your DB from damage or corruption.
Cheers,
Got an idea..share it !!
DBA_Vishal
September 16, 2009 at 2:53 am
vkundar (9/16/2009)
find out the reason why the backup failed? Take another backup. Backup is very much necessary to bring up your DB from damage or corruption.
To follow on what was said, if you dont understand how to find out how it failed or you want to know how to fix the issue, post the error message for us to look at.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 16, 2009 at 4:47 am
You can look at SQL Server Error log file to find out the reason for your backup failure issue. Some details can also be found on Event Viewer.
See the error details and error number and try to find out the possible reason for failure.
In any case, first take a Full backup of database and then play around. Ensure that you must have enough disk space and correct permission for taking the database backup.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply