Posts Tagged ‘sql server’

SQL Server 2008 – attach database failed – reason 1815 error 5120

We had to reinstall the DB cluster today and almost ended up pulling our hair out because after a successful detach and backup of the mdf and ldf files we couldn’t get them to attach without errors again. Then we found this article which says: do not forget to make sure that the folder and [...]

This article has no comments. Why not add yours?

on Thursday, 28th May, 2009

, , , , , , ,

development, troubleshooting

no comments

Downgrade bak file from SQL Server 2008 to SQL Server 2005 (or earlier)

Ran into a problem today: our development is currently on a server running SQL Server 2008 yet our live environment is running SQL Server 2005. Migrating from earlier SQL Server 2005 to SQL Server 2008 is easy, backup a database (create a bak) and restore on the new database. Even detaching and reattaching works the [...]

This article has no comments. Why not add yours?

on Tuesday, 18th November, 2008

, , , , , , , , , , , ,

troubleshooting

no comments