We have a 1.5TB database. I could create some replication strategies do replicate the database to another server in a fixed time.But the developers don't know when they will need to replicate this development database to the teste environment.
So, i have 1TB database in the development server.I will ( I already did it ) full backup the database, and restore it in the test server. then, I would like to restore only the modifications ( because to restore everytime the full database will take a LOT of time ).
I'm trying to make a little test with 2 databases:
I created 1 database, did a full backup, and restored it. but when i try to only restore the log, I receive this error:
restore log banco_2 from disk ='e:\backup\banco1_primeiroLog.bkp' with recovery
Msg 3117, Level 16, State 1, Line 13 The log or differential backup cannot be restored because no files are ready to rollforward. Msg 3013, Level 16, State 1, Line 13 RESTORE LOG is terminating abnormally.
Should I use diff backups for this task? What would be the best strategy to this? If the question is confuse I can fix it.
I'm trying to follow this question's answer but its not working :