Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Backup Types Expand / Collapse
Author
Message
Posted Sunday, October 10, 2010 10:16 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:27 AM
Points: 1,130, Visits: 1,390
Thanks Tom Thomson for all backup types.

Thanks
Post #1001903
Posted Friday, October 15, 2010 10:04 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, September 15, 2014 9:28 AM
Points: 629, Visits: 140
I have never used Incremental backup but I kind of remember reading somewhere about it as a new addition to SQL 2005 when it first came out. I never went back to dig into it as I care much less about this new backup feature as I was not going to use it anytime soon but it was somewhere in the back of my head that it is there if I happen to need it in future.

I read somewhere on online posting, long time ago that Incremental Backup backs up database since the last full backup and the last incremental backup whereas Differential Backup backs up database since the last full backup.
Post #1005330
Posted Friday, October 15, 2010 10:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:54 AM
Points: 5,579, Visits: 6,363
JustStarted (10/15/2010)
I read somewhere on online posting, long time ago that Incremental Backup backs up database since the last full backup and the last incremental backup whereas Differential Backup backs up database since the last full backup.


Nope. Sorry. Lots of people call Transaction Logs by the name Incremental, which unfortunately persists the myth. It's a bad name to call it since Incremental really does exist for other software products.

EDIT: Just a note. Transaction Logs do not behave the way you've listed Incrementals as behaving. It's similar behavior, but you need every Transaction Log up to the most current or your P.I.T. in order to properly restore the database.

Incremental just doesn't exist for SQL Server. See my SQL Misconceptions post for T-SQL Tuesday this month.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1005344
Posted Tuesday, October 19, 2010 1:08 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
Nice Question. logged back after a long time and got it wrong.
Post #1006741
Posted Wednesday, October 20, 2010 12:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 10:39 AM
Points: 1,194, Visits: 787
I guess incremental Back up was there only in oracle :)
Post #1007477
Posted Thursday, December 9, 2010 6:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:10 PM
Points: 2,669, Visits: 781
Strange... backing up files in Diff format... never knew.

Jamie
Post #1032435
Posted Wednesday, December 15, 2010 5:18 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 6:09 AM
Points: 697, Visits: 356
I don't know about partial backup .can any guys help me?
Post #1035035
Posted Wednesday, December 15, 2010 5:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:54 AM
Points: 5,579, Visits: 6,363
What do you want to know?

The easiest way to learn the basics is to look up Partial Backup in Books Online. But if you've already done that and have specific questions, feel free to ask.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1035046
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse