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 |
|
eatha
Starting Member
2 Posts |
 Posted - 2010-08-09 : 04:54:22
|
| I need help please,I want to backup my data on SQL Server 2000, but not all of them...I just want to backup data on 2007 until 2009, so I can deleted the existing data on database n free my server space..I ever searching it but i didn't get the solution..Does anyone know, how to do it..? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-09 : 05:26:54
|
| If you meant data from tables only and not any other objects, try bcp out the data to text files and delete them from the tableMadhivananFailing to plan is Planning to fail |
 |
|
|
eatha
Starting Member
2 Posts |
Posted - 2010-08-09 : 05:41:38
|
| I mean, I have a large number of data, and now the space of my servers are almost full, so I want to backup the data from all of tables and databases...The problem is in each table there is data from 2007 until 2010, so I want to back up the data from 2007 up to 2009, then I can deleted the data from 2007 up to 2009 in my databases and leave the 2010 data... |
|
|
|
|
|
|
Backup Some Data in SQL Server 2000