October 2, 2013 at 1:44 pm
Hello All,
How to archive the entire database in SQL Server 2008r2
Thanks,
Santosh
October 2, 2013 at 2:21 pm
santhosh411 (10/2/2013)
Hello All,How to archive the entire database in SQL Server 2008r2
Thanks,
Santosh
Have you tried google? I typed in your question EXACTLY and the very first hit in google is what you want.
https://www.google.com/#q=How+to+archive+the+entire+database+in+SQL+Server+2008r2
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 3, 2013 at 2:47 am
You need to better define what you mean. You can create a backup as was described above. That creates a copy of the database. It's a fundamental part of protecting your system. Then, there is archiving data. That's a means of pulling data out of the database, storing it in some other location, usually another database, in order to reduce database size or get rid of old data. Which of those two things are you trying to do?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply