May 14, 2009 at 3:15 am
hi.. i just want to ask whether the existing database that is corrupted be deleted and redo a new database? Does it affect anything? Please help!!
May 14, 2009 at 3:27 am
What do you mean by "redo a new database"? Restore from backup?
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
May 14, 2009 at 6:45 pm
ya..means that can i delete the previous db (cause of corrupted) and make a new (restore) the same db into the system? does it affect anything?
May 14, 2009 at 6:52 pm
It depends on what backups you have. If your most recent backup is from last Sunday night, and you've done a bunch of work in the database since then, and then you delete the database and restore the backup, you'll have lost all your work since Sunday.
If nothing's changed, you won't lose anything. Be careful though, do a test restore of the backup first somewhere else before deleting the database - if you delete it and find the backup is corrupt, you may be left with nothing.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply