472,096 Members | 1,184 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

Question about differential restores (SQL Server 2005)

Hello everybody,

I'm not all that familiar with backing up and restoring databases on SQL 2005 and I have a question. First, let me give you a little insight into how we're setup and what we want to do.

We have two servers--live & test. Currently, we perform a full back of the live server each night and restore it to the test server. This all runs automatically. It's been requested that it would be nice to have the test server receive differential restores during the day to keep it updated with the live server. So my question is this:

Since we're doing FULL backups and restores, can we do differential backups on the live server and restore to them test periodically during the day? Can we restore differentials on DB that been restored with a FULL backup?

Thanks for your help! :)
Dec 9 '09 #1
1 1501
149 100+
Check these out:

a) SQL Server 2005 Backups

b) Differential Database Backups for SQL Server

hope this helps
Dec 10 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by tim groulx | last post: by
1 post views Thread by malcolm | last post: by
7 posts views Thread by What-a-Tool | last post: by
1 post views Thread by Eric J. Holtman | last post: by
20 posts views Thread by fniles | last post: by
2 posts views Thread by esource | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.