January 11, 2011 at 1:55 am
A database is size is 1tb how to take full backup of the database.
January 11, 2011 at 2:07 am
sudeepta nanda-402098 (1/11/2011)
A database is very large how to take full backup of the database.
How "large" is "very large" ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2011 at 2:12 am
http://msdn.microsoft.com/en-us/library/ms179401.aspx.
same approach for restoration.
----------
Ashish
January 11, 2011 at 2:50 am
Well, you can take backups the same way you take them for small databases. BACKUP DATABASE still works. It may be impractical because of the time, but it does work.
There are lots of options for backing up large databases. You can use native backups and back up and the file or filegroup level. Stripe the backups over multiple physical drives to increase performance there,
You can upgrade to SQL 2008 (Enterprise edition) and use backup compression, or buy one of the 3rd party backup tools that offer compression (Redgate's SQLbackup or Quest's Litespeed come to mind)
If you're running on a SAN you can investigate and see if the SAN vendor has a snapshot backup solution for SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply