November 27, 2013 at 2:36 am
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??
November 27, 2013 at 2:58 am
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://qa.sqlservercentral.com/articles/books/89519/ (the e-book/pdf version is free of charge)
November 27, 2013 at 3:06 am
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??
November 27, 2013 at 3:39 am
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
December 2, 2013 at 3:59 am
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
December 6, 2013 at 4:34 am
How can i Know whether my Database structure supports partial backups???
December 6, 2013 at 5:04 am
Did you read the link that Grant posted?
John
December 6, 2013 at 5:10 am
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/
December 6, 2013 at 5:19 am
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
December 6, 2013 at 7:25 am
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply