Archive Automation | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
I need to pull the database older than 60 days.Can somebody please help me with a script to do that.
Thanks for your help in advance!
Welcome to the forums!.
What exactly do you mean by "pull the database" please?
select * from table
Create Archive Database and then create a archive table as you want then write a query as
INSERT INTO archivedatabase.dbo.archivetable
SELECT * FROM sourcedatabase.dbo.sourcetable
where datecolumn <= getdate()-60