DevPinoy.org
A Filipino Developers Community
Forums » Database Servers » SQL Server » Database Archiving
   

Database Archiving

rated by 0 users
This post has 1 Reply | 1 Follower

Top 500 Contributor
Posts 4
Points 80
Reply
DOBius Posted: 06-24-2009 2:47 AM

Hi Guys,

what is the best way / solution to archive a database in MSSQL Server 2000.

 

Thanks

 

Feljun

Did you remember the day you remembered yourself?
  • | Post Points: 20
Top 75 Contributor
Posts 23
Points 295
Reply
bass_player replied on 07-14-2009 9:27 PM

You can try doing filegroups. Move the archived data to a different filegroup by creating a table on the new filegroup that will contain the archived data. This might complicate your disaster recovery process, though

  • | Post Points: 5
Page 1 of 1 (2 items) | RSS

Copyright DevPinoy 2005-2008