Anukul (4/2/2009)
Can you provide a script to restore all differential backs hour after hour?
No need. It's trivial. Add WITH NORECOVERY to all of your restored. However that means that the database on the test server is not readable.
What you are trying to do cannot be done with backups (leave a database read-write but still be able to restore further backups)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability