May 31, 2009 at 12:24 am
Hi All,
We are having a Database of almost 700 GB in Sql-Server 2005. We are trying to take the backup of the database through NTBACKUP command. its taking almost 2 hrs and showing a warning
Backup is completed successfully with some skipped files.
When i am going through the report, its showing that
corrupts files:1
Restore will not happen
Could anyone please help me out.Its very urgent for me to take the backup.
Awaiting for suggetions.
Thanks,
Praveen
May 31, 2009 at 2:51 am
You should not be trying to backup the SQL data and log files using NTBackup. The files are locked by SQL server and either NTBackup will skip them or it will try to back them up, maybe succeed but the files will not be usable.
Back the database up using the SQL backup command (BACKUP DATABASE ...) and then use NTBackup to back that file up to another location.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2009 at 11:07 am
Thanks for your suggestion.
Can you give me the exact procedure to follow to take backup.
I have to do the backup on tape.
June 2, 2009 at 4:46 pm
tikkani.praveen (6/2/2009)
Can you give me the exact procedure to follow to take backup.
Look up BACKUP DATABASE in Books online. If you have questions after, please ask them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply