sql version Mirror-replication

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

General SQL Server Forums

New to SQL Server Programming

sql version Mirror-replication

Author

Topic

nobby
Yak Posting Veteran

58 Posts

Posted - 2007-06-13 : 10:12:31

Hi i have tried a search on this topic but didn't find much.

I have my fiest sql db live on my we server and all works fine, more luck than skill i think.

But now i wory about backing up my data i have tried various tools backing up the db every 5 minutes and then sending it too another server via ftp this tool works fine but when we have a few people on and the db is accessed frequently it can't back it up i assume this is to do with the backup tool needing an exclusive lock on it.

What is the difference between Replication and data mirror both of these seem to be talked about alot and is there a simple guide somewhere on how to set these up.

Or if i am coming at this from totally the wrong angle then please let me know

Thanxs

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-13 : 10:39:36

Mirroring only works on sql2k5. You can use replication or log shipping to sync the db to backup server, depends on if you need real time db sync or not. By the way, whick backup tool do you use? Sql backup doesn't need exclusive lock on the db.

nobby
Yak Posting Veteran

58 Posts

Posted - 2007-06-13 : 10:50:42

i am using sql 2005 express
At the moment i use handy backup pro because it zipps up the database and log files and ftp's them to my second server every 5 minutes and woorks fine as long as there are no locks on the table then it can't back them up.

I have setup a online tournament game and when a few people are playing the database is recieving about 1000 entries an hour my concern is loosing there scores and when people pay us i lose their subscription details.

At the moment i am only small so looking for a cheap easy solution because i am learning as i go.

Main concern data loss/corruption

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-13 : 11:01:18

Then you can't use db mirroring. Take look at log shipping, much smaller file size and no exclusive lock needed.

nobby
Yak Posting Veteran

58 Posts

Posted - 2007-06-13 : 11:23:47

As you can probably guess i am fairly new to this,
What about replication wouldn't that ensuure an identical database on a different machine ( i don't know the first thing about sql replication but the name of it sounds right)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-13 : 11:30:59

Replication needs connection between two sql servers. What's your environment details?

nobby
Yak Posting Veteran

58 Posts

Posted - 2007-06-13 : 11:47:01

Right, i have 2 dedicated webservers in datacentres i also have a webserver on my fixed IP broadband connection.
all are running sql express 2005
one websever is is windows 2003 the other is windows 2000 sever and the one on the fixed ip is also win 2k server hope this is what you meant

at the moment my site is not very big and i find a straight copy of the database is easy to restore because you just copy it to the server and attach it so what i was hoping to do was carry on with acopy of the database every 5 minutes as disaster recovery but also have replication so if everything is all right i can copy that to the main server attach it and hey presto, but i doubt it's that simple or easy
Thanxs for the help

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-13 : 12:43:59

Sql2k5 express can be replication subscriber only.

nobby
Yak Posting Veteran

58 Posts

Posted - 2007-06-13 : 13:00:59

Sql2k5 express can be replication subscriber only.

sorry very new only recently changed to sql from access so don't have a clue what these means or how i would use it

nobby
Yak Posting Veteran

58 Posts

Posted - 2007-06-13 : 18:32:45

Sql2k5 express can be replication subscriber only.

Can anyone tell me what this means

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-13 : 21:40:04

That means you can't use replication among sql2k5 express machines, find details in books online.

nobby
Yak Posting Veteran

58 Posts

Posted - 2007-06-14 : 11:17:18

What is the cheapest version of ms sql i can mirror/replication with