469,330 Members | 1,322 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,330 developers. It's quick & easy.

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 1437
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 zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.