Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramil85
Starting Member
2 Posts |
 Posted - 2015-03-05 : 06:41:57
|
| i want to backup records for last year(and do it each year), and delete this records. But later in case i need old data, restore data for the year that i want, use it and remove it again.is it possible on MSSQL 2005? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-03-05 : 07:32:21
|
| Of course, just not with the backup command |
 |
|
|
ramil85
Starting Member
2 Posts |
Posted - 2015-03-06 : 05:22:10
|
quote:
Originally posted by gbritton
Of course, just not with the backup command
could you give an example? |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-03-06 : 05:55:04
|
| Easiest using SSIS. Otherwise partition the tables and switch the older partions to archive tables |
|
|
|
|
|
|
how to perform partial backup?