Home Forums SQL Server 2008 SQL Server 2008 - General SQL DB Administration RE: SQL DB Administration
Suresh B.
SSC-Insane
Points: 22986
More actions
September 22, 2012 at 12:30 am
#1541049
Following are important steps
1) Check database integrity
2) Backup database
3) Backup Transaction Log
Additional points:
1) Backup both user and system databases.
2) If the data and log files are on same drive, move them to different drives