November 22, 2009 at 6:04 pm
Hi,
Can I ask if what's the impact if i change the recovery model of my ms sql server 2005 and 2000 databases? (from simple to full and vice versa). What's the difference between this models? What's also the difference between backing up a database in full, transaction and differential? I'm new to database administration. Thanks in advance.
Dominicus 🙂
November 22, 2009 at 6:28 pm
There is no difference in SQL Server 2005 and 2000. Read the article below for a good idea about it.
Managing Transaction Logs By Gail Shaw[/url]
Then look at the Books Online how to topics below
Backing Up and Restoring How-to Topics (SQL Server Management Studio)
Finally one simple example.. http://www.sqlservercentral.com/Forums/Topic822796-146-1.aspx#bm822804
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 22, 2009 at 7:55 pm
Thanks for the info. How about differential backup? it was not mentioned in you article.
November 22, 2009 at 8:23 pm
A differential backup backs up any pages that have been changes since the last full backup. It is not affected by changing recovery models.
November 22, 2009 at 9:03 pm
dominicgurat (11/22/2009)
Thanks for the info. How about differential backup? it was not mentioned in you article.
In continuation with happycat, since differential backups backup the data since the last full backup,they are cumulative, so in a series of differential backups, the last known working differential backup is good enough to bring the data back to that moment.
This is opposite to the transactional log backups, where the chain of transaction log backups have to be available to recover to the entire data.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply