RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

SQL Server “IN RECOVERING” State

SQL Server “IN RECOVERING” State

 

Quickly Solutions to solving.

1.     Stop the service (MSSQLSERVER);

2.     Rename or delete the Database and Log files (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data...) or wherever you have the files;

3.     Start the service (MSSQLSERVER);

4.     Delete the database with problem;

5.     Restore the database again.

 

DETACH TO CLEAN CATALOG IF SQL SERVER DONT WORK CORRECTLY

If necessary detach with:

1) Code Snippet

dbcc detachdb('UserData')

2. delete the physical data files

 

Categoria: Sql Server ALL
mercoledì, 30 giu 2010 Ore. 18.33

Messaggi collegati


Statistiche
  • Views Home Page: 416.208
  • Views Posts: 844.843
  • Views Gallerie: 0
  • n° Posts: 345
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003