InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:08:10 GMT20http://www.sqlservercentral.com/Forums/Topic1017581-391-1.aspxi had detached suspected database in s2k8R2. i have full backups? problem is i'm not able to attach.planning to restore the db.plz suggest. it's urgently needed.Sun, 18 Nov 2012 15:23:14 GMTprakashmudduhttp://www.sqlservercentral.com/Forums/Topic1017581-391-1.aspx[quote][b]sachin-355820 (11/9/2010)[/b][hr]Is the last full backup and log file available.If yes then you need to1)Take a Tail log backup.[/quote]Database has been detached so log file wont be available.[quote]2)Create a new database and then restore the full backup.[/quote]No need to create a new database. Restore will be just fine.[quote]3)Restore the Tail log backup.[/quote]All subsequent log backups taken after full backup need to be restored in sequence first before restoring tail log backup(if that is available, in this case it is not)Tue, 09 Nov 2010 01:19:36 GMTps.http://www.sqlservercentral.com/Forums/Topic1017581-391-1.aspxIs the last full backup and log file available.If yes then you need to1)Take a Tail log backup.2)Create a new database and then restore the full backup.3)Restore the Tail log backup.Tue, 09 Nov 2010 00:11:44 GMTSachin Nandanwarhttp://www.sqlservercentral.com/Forums/Topic1017581-391-1.aspxA suspect database should never have been detached!! you can try doing what was suggested in previous post. do you have backups?Mon, 08 Nov 2010 22:34:50 GMTps.http://www.sqlservercentral.com/Forums/Topic1017581-391-1.aspxYou need to "hack" the database back into SQL server. 1. Create an empty database on the server to match the real database in size, name, files, etc.2. Stop SQL Server services.3. Copy the real database files (mdf,ndf,ldf) to the locations of the empty database you just created.4. Start SQL Server and the real database should come up suspect.5. Run ALTER DATABASE <yourdbname> SET EMERGENCY6. Run DBCC CHECKDB to find out why the database is suspectIf this is a production database you should probably call Microsoft support.Mon, 08 Nov 2010 22:04:18 GMTJeremyEhttp://www.sqlservercentral.com/Forums/Topic1017581-391-1.aspxhello to all i would like to ask some assistance for attaching a suspect db a size of 400 gigz, here what happen in our prod DB. we try to run the sqlserver 2008 R2 and we found out that our DB is in suspect mode i dont know what cause then one of the IT personnel detached it while in a suspect mode then he tried to attached but it does not attach at all..is there a way to attach this database? please help we need it badly..thanksMon, 08 Nov 2010 21:08:17 GMTjolan.mahinay