Best Backup Procedure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Best Backup Procedure

Author

Topic

abhishekanand
Starting Member

3 Posts

Posted - 2007-11-28 : 05:18:00

Hi ,

I want to know what is the best way that most of the companies are using to backup the database ,so the data lost will be minimum in case of the server crashes.
Please reply

Abhi

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2007-11-28 : 05:50:34

There are many options:
1) Clustering
2) Databse Mirroring
3) Log Shipping
4) Backup
Depending on the your comapanies needs, you have to use them.

Suresh B.

Arpan
Starting Member

3 Posts

Posted - 2007-12-01 : 01:48:54

As per me best backup procedure is as follows:

1: Schedule complete backup at midnight or in Off peak hours (Once in a day).
2: Schedule transaction log backup daily after every 20 or 30 mins appending the same backup file, tlog should start after complete backup and last tlog backup should be before complete backup.

so if at any point your database gets crashed, you can apply complte backup followed by tlog backup.

And Log Shipping is the best way, if you can get all the resources.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources