Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta

SQL Server 2005 database watch

    • Thread Starter

    In general, theproblem is the following: On your computer was SQL Express 2005 database werein Program Files, the existence of this computer SQL I knew (learned after)demolished Windows put the new, then restored 2 files mdf and ldf, while hasfound 2 months old backup, backup restores all data work but not the same.Tried to attach it restore data produces an error on the files I / O. Thentried to create a database with the same name and the substitution of the file,the database becomes suspect when the dbcc checkdb gives an error"Database is restored wait until the" end up as neither of which isnot out. How to restore performance database I do not know (or at least howthese restore files to pull the data and put in a new one). Another was theidea of ​​applying changes from ldf at the base of the backup, but the way I donot find someone that can advise. That mistake goes with the attaching restorefiles:Microsoft SQLServer Management Studio:Action Attachdatabase failed to object "Server" "SERVER1C".(Microsoft.SqlServer. Smo)

    Jesus christ, what an incoherent load of waffle. I have no idea what the question is.
Submit reply
Turn on thread page Beta
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Updated: March 31, 2016
Have you ever experienced racism/sexism at uni?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.