August 31, 2012 at 9:56 am
how to take back up from offline data base
August 31, 2012 at 9:59 am
Bring it online first, take the backup and take it back offline.
August 31, 2012 at 10:01 am
Thanks for u r reply.. i mean the data base not available corrupted... i need to take back up is there option available
August 31, 2012 at 10:48 am
m.rajesh.uk (8/31/2012)
Thanks for u r reply.. i mean the data base not available corrupted... i need to take back up is there option available
You said it is corrupted? What good is a backup of a corrupted database going to provide? Sounds like you need to restore to an older backup and then do a point in time restore to just before the corruption occurred if you know when that was.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply