Server Management (Insight Manager 7)
1832286 Members
2199 Online
110041 Solutions
New Discussion

Archiving SQL Server database

 
Chacko
New Member

Archiving SQL Server database

My Client wants to Archive old records from a Ms SQL Database to a new Database in SQL Server.But while Archiving , the Client may not know the relationship set in the tables so while transfering a table any table related to this tables should also be moved to the new database.
Is there is any feature available in Ms SQL server for this/Is there is any separate software for the above archiving process?