May 12, 2016 at 2:25 pm
Evening All,
In the process of migrating a small DB to SQL Server 2014, I've managed to mark one of the DB's as suspect because it was set to read only during the SP4 upgrade. It was previously SP3.
Does anyone know if I can salvage this DB?
Things I am thinking is Detach/Reattach, in the hopes its a system table problem - perhaps it doesn't recognise the old system tables since it could not upgrade them?
The other option is detach, reattach to a fresh SQL 2000 SP3 build?
The reason I was upgrading to SP4 was so that I could then backup/restore to SQL2008R2, and then perform another backup restore onto 2014. But I've fallen at the first fence! Sadly.
Help, as always mucho appreciado!
Cheers,
Alex
May 13, 2016 at 12:33 pm
Just to update and close this thread for any others reading:
This was solved simply by bringing the database online with alter database!
Pretty annoyed that I did't try that first before posting... But oh well, lesson learned!
Cheers
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply