How Can I create a fresh copy of a large database on SQL Server?
I have a very large database 400GB that is now corrupted. I tried reparing it with repair_allow_data_loss option but that did not fix the problem so my next option is to restore to a previous version. What I want to do first it to create a new fresh copy of the database. So a database with all the tables/views/prosedures/permissions like the existing one and they restore to it an older backup.
So How can I create this fresh copy?
Thanks
I have a very large database 400GB that is now corrupted. I tried reparing it with repair_allow_data_loss option but that did not fix the problem so my next option is to restore to a previous version. What I want to do first it to create a new fresh copy of the database. So a database with all the tables/views/prosedures/permissions like the existing one and they restore to it an older backup.
So How can I create this fresh copy?
Thanks
No comments:
Post a Comment