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

part of database backup Expand / Collapse
Author
Message
Posted Wednesday, November 27, 2013 2:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
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??
Post #1517950
Posted Wednesday, November 27, 2013 2:58 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 5:37 AM
Points: 498, Visits: 1,845


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)
Post #1517956
Posted Wednesday, November 27, 2013 3:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
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??
Post #1517959
Posted Wednesday, November 27, 2013 3:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
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 2008, MVP
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

Post #1517976
Posted Monday, December 2, 2013 3:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, September 29, 2014 9:27 PM
Points: 13,776, Visits: 28,178
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1518826
Posted Friday, December 6, 2013 4:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
How can i Know whether my Database structure supports partial backups???
Post #1520509
Posted Friday, December 6, 2013 5:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 5,388, Visits: 9,971
Did you read the link that Grant posted?

John
Post #1520518
Posted Friday, December 6, 2013 5:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 5, 2014 6:19 AM
Points: 147, Visits: 591
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
Post #1520520
Posted Friday, December 6, 2013 5:19 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
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 2008, MVP
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

Post #1520522
Posted Friday, December 6, 2013 7:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
http://technet.microsoft.com/en-us/library/ms191539.aspx
Post #1520579
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse