SQLServerCentral » Latest topics
Recover corrupted database
I am facing a situation like this:
I some ndf files deleted accidentally and the latest backup refers to yesterday
I create the same database and overwrite main database files on new one.
then :
ALTER DATABASE [MyDb] SET EMERGENCY;
I some ndf files deleted accidentally and the latest backup refers to yesterday
I create the same database and overwrite main database files on new one.
then :
ALTER DATABASE [MyDb] SET EMERGENCY;
No comments:
Post a Comment