Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2007-11-07 : 17:17:31
|
| Hi Experts,How can we check The restored database is succesfully had every data as the original Database? (i.e Every tables, Stored Procedures, Views Etc..... are same in both databases or not)-Thanks N Regards,Kanthi. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-07 : 17:18:34
|
| The restored database will have everything, so you just need to check its integrity via DBCC CHECKDB.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-08 : 00:48:12
|
| There is quite a lot of "noise" output by DBCC CHECKDB so I prefer to useDBCC CHECKDB('MyDatabaseName') WITH NO_INFOMSGSKristen |
|
|
|
|
|
|
How to Check DB's after Restore