RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

How to repair a SQL Server 2005 Suspect database

How to repair a SQL Server 2005 Suspect database Check DB Sometimes when you connect to your database server, you may find it in suspect mode. Your database server won’t allow you to perform any operation on that database until the database is repaired. A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc. To get the exact reason of a database going into suspect mode can be found using the following query, DB 
Leggi tutto il post...
Categoria: Sql Server ALL
venerdì, 20 feb 2009 Ore. 16.54

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003