part of database backup

Question

part of database backup

$t@r

SSCommitted

Points: 1751
More actions
November 27, 2013 at 2:36 am

#282853

Hi,
Is it possible to backup part of database.
i have 2 yrs data in my database can i backup last yr data only??
if possible
whenever i want full database can i combine those 2 backup??
how can i get full database??

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

i have 2 yrs data in my database can i backup last yr data only??
if possible

Not unless it's already in a specific file, I don't think: http://technet.microsoft.com/en-us/library/ms179316%28v=sql.105%29.aspx

whenever i want full database can i combine those 2 backup??

Which two backups? You would just carry out a full backup if you wanted to back up the full database.

how can i get full database??

It's not clear what you mean.

Before you go any further you should try to read this book http://www.sqlservercentral.com/articles/books/89519/ (the e-book/pdf version is free of charge)

$t@r SSCommitted Points: 1751 More actions · Answer 2

my question is can i take backup of half of the database means

can i remove last yr data from my database and keep it as a backup??

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

You can back up the entire database and then delete the older data. You can't take a backup of part of a database unless the database has multiple files or filegroups and has been designed to allow partial backups to work effectively.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 4

This introduces the concept of the a partial backup. As everyone has already stated, you can only do this if you design the database and it's structure to support the concept.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

$t@r SSCommitted Points: 1751 More actions · Answer 5

How can i Know whether my Database structure supports partial backups???

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 6

John Mitchell-245523

SSC Guru

Points: 148809

December 6, 2013 at 5:04 am

#1671464

Did you read the link that Grant posted?

John

PravB4u Default port Points: 1401 More actions · Answer 7

refer below articles..

https://www.simple-talk.com/sql/backup-and-recovery/partial-backup-and-restore/

http://www.mssqltips.com/sqlservertutorial/27/sql-server-partial-backups/

Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

PravB4u (12/6/2013)
http://www.mssqltips.com/sqlservertutorial/27/sql-server-partial-backups/

That one is quite misleading and has no discussion of the considerations or requirements. I'd avoid it.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jitendra.padhiyar SSCertifiable Points: 5824 More actions · Answer 9

http://technet.microsoft.com/en-us/library/ms191539.aspx