So we are using Veeam to backup the entire Virtual machine. That backup is being planned to be restored to another box and from there the full backup and the transaction log backup will be copied to a test box. I have installed SQL server 2008 on this test server. Will I be able to restore the SQL Server database on this test server or do I need to change something?
I am not 100% clear on what you are asking. So Veeam is going to backup and restore the Virtual machine. Clear on that. On that virtual machine you have the database backup and logs. You will then copy those backups and logs to another test machine you have that you installed SQL 2008 on and want to know if you can restore those backups and logs. Is this what you are asking? If so then yes, but I am not clear why you would need to restore the Veeam backup to copy the backup files. Just copy from the current online virtual machine to your test server and validate you can restore the database backup file and log files. As long as you are restoring to the same version of SQL or newer and have valid backup files you can restore. If I misunderstood your question please let me know.
RESTORE DATABASE [CVS] FROM DISK = N'D:\CVS_backup_2015_03_13_000001_2723238.bak' WITH FILE = 1, MOVE N'CVSNET_Data' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\CVS.mdf', MOVE N'CVSNET_Entity' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\CVS_1.ndf', MOVE N'CVSNET_Relational' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\CVS_2 .ndf', MOVE N'CVSNET_Reference' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ CVS_3.ndf', MOVE N'CVSNET_Note' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ CVS_4.ndf', MOVE N'CVSNET_Transaction' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\ MSSQL\DATA\CVS_5.ndf', MOVE N'CVSNET_System' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER \MSSQL\DATA\CVS_6.ndf', MOVE N'CVSNET_Audit' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER \MSSQL\DATA\CVS_7.ndf', MOVE N'CVSNET_Log' TO N'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\CVS_8.ldf', NOUNLOAD, STATS = 10 GO ----------------- This is the scripted restore file. Where do I put no_recovery option in this script to further allow application of difflog and tlog?
I am able to restore the full backup and 2 tlogs. But any attempt to apply other tlog backup gives me following error: RESTORE LOG [CVS] FROM DISK = N'D:\SQLfiles\CVS_backup_2015_03_14_020001_5024109.trn' WITH FILE = 1, NOUNLOAD, STATS = 10,norecovery GO Msg 4305, Level 16, State 1, Line 1 The log in this backup set begins at LSN 254230000000371700001, which is too recent to apply to the database. An earlier log backup that includes LSN 253906000004847800001 can be restored. Msg 3013, Level 16, State 1, Line 1 RESTORE LOG is terminating abnormally.