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 2008 Forums
 Transact-SQL (2008)
 Online Backup

Author  Topic 

loknathmahato
Starting Member

27 Posts

Posted - 2011-11-07 : 06:40:07
Hi Friends,

I have 15 GB database and 4 gb Log file, 8GB RAM , In a minuts there are 2 to 3 hundred query are fired for update,delete and insert. Can somebody advice me that for online backup which will be better
1)Mirroring
2)Replication
3)Log shipping

or any other ....

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-07 : 06:53:21
Backup or high availability? All three of those things are high availability, not backups.

As for which is better, depends on your requirements, your budget, etc.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -