From: Dan Guzman on 4 Feb 2010 08:10 > You mean it is possible even if we did not detached it first? > I am going to try it now. An attach will likely work even if the database was not cleanly detached as long as all files are available. You can attempt an attach as part of a DR scenario but I suggest you don't rely on it succeeding. Always be prepared to restore from your last known good backups in your DR plan. -- Hope this helps. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/ |