• DBA

    Restoring a database from higher version to lower version SQL server

    Restoring a database from higher version to lower version SQL server How to downgrade a database from higher version to lower version? There is no direct way to do this like Backup/Restore. You can use an alternative ways. The alternative ways are,   1. Generate Script 2. Import/Export 3. Transaction replication You may use the alternative ways. It depends upon your environment. Restore errors A backup has taken from higher version (SQL 2008/2005) BACKUP DATABASE dba_test TO DISK='E:\mu\dba_2008.bak' Restore the backup to lower version (SQL 2005/2000)   RESTORE FILELISTONLY FROM DISK ='E:\mu\dba_2008.bak'   Restore error from SQL server 2005 to SQL server 2000 Server: Msg 3205, Level 16, State 2, Line 1 Too many backup…