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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy