![]() Processed 24480 pages for database 'SalesDB', file 'SalesDBData' on file 1. MOVE N'SalesDBLog' TO N'C:\SQLskills\SalesDBLog.ldf', WITH MOVE N'SalesDBData' TO N'C:\SQLskills\SalesDBData.mdf', ![]() RESTORE DATABASE FROM DISK = N'C:\SQLskills\SalesDB2005.BAK' ![]() DatabaseName DatabaseVersion DatabaseCreationDate SELECT HEADERONLY FROM DISK = N'C:\SQLskills\SalesDB2005.BAK' Here’s the proof, restoring a SQL Server 2005 database directly to SQL Server 2016, and I tried it successfully on SQL Server 2014 and SQL Server 2012 as well. I didn’t know this until a few weeks ago, and it’s not common knowledge, hence this short blog post. You just can’t do an in-place upgrade to the latest version from SQL Server 2005. You can backup+restore (safest way) or detach+attach (not a safe way) from SQL Server 2005 (or higher) to any other newer version. ![]() There’s a persistent myth that you cannot upgrade a database to a version more that is more then two versions newer. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |