Tutorials on archiving full database

Why we need to do Sql  Data archiving ?

Today‘s world there is a huge need for doing data archiving, even though the server is secured and has a backup facility, if your database is growing exponentially we need to give way to new data and backup the old data, creating a backup of database not only saves your cost and time but also the data can be restored in the sql data recovery process.  Reporting will be faster when you regularly schedule a backup of the databases.

Microsoft Sql Server 2008 – Data Archiving?

Ms SQL server is the popularly and widely used server around the world, big applications, large web portals rely upon this server. Now we will see how to take a backup in Microsoft Sql Server.  Steps involved in doing data archiving.

Data archiving of full database?

In Ms SQL 2008 archiving is easy through the help of  SQL Server Management Studio To do Ms Sql data archiving you need to follow these steps:

  • Connect to the desired Microsoft Sql Database engine, click Object explorer from there select the server name and expand the sub menu’s.
  • Select a system database from the expanded sub menu
  • Right click the selected database and then click the context menu named Backup. Dialog box will open with the list of databases you can select any database from the list.
  • Four type of data recovery is possible like Simple, Logged, Bulk and Full. Now we are going to do full data archiving of database click full from the list of options.
  • Two types of Data archiving is possible, Copy only backup and Differential backup. Copy only backup is not a conventional backup because when you take a backup of a database, there are chances that a database could be changed while taking a backup or it can create a problem when restored.
  • Click backup component and select Database and type a name for the backed up database and specify the location where it has to be stored.
  • Finally select the location of where the backup has to be stored select type whether the data needs to be stored in a tape or hard drive. After selecting it select the Overwrite media option as Backup with the media set and make sure you check the reliability option .