Sunday, February 17, 2013

SQL Server ERROR 9001


In order to resolve the issue, I have followed the steps below: 1) Taken the database offline and online 2) Executed the query given below : USE [your_databseName] GO ALTER DATABASE [your_databseName] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE('your_databseName_log', 1) ALTER DATABASE [your_databseName] SET RECOVERY FULL WITH NO_WAIT GO

No comments:

Post a Comment