Ross Turner
asked on
MS SQL Replication / Mirroring / Log Shipping Query
Hi EE,
I've got a couple of 2005 MS SQL Databases and we are wanting to create them on another server for reporting purposes only... (i suppose a data warehouse of sorts).
The databases don't need to be live to the minute, however they are all pretty small... e.g 3-4gb
I'm just looking for some advice on the best options and any pitfalls anyone has encountered.
Many thanks
Ross
I've got a couple of 2005 MS SQL Databases and we are wanting to create them on another server for reporting purposes only... (i suppose a data warehouse of sorts).
The databases don't need to be live to the minute, however they are all pretty small... e.g 3-4gb
I'm just looking for some advice on the best options and any pitfalls anyone has encountered.
Many thanks
Ross
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Any further assistance required?
ASKER
Hi EvilPostIt <---- love the name by the way
I just been testing the mirroring solution... i just been having some bother with it but i'm getting there slowly.
Once i got it tested i'll assign point :)
Cheers
Ross
I just been testing the mirroring solution... i just been having some bother with it but i'm getting there slowly.
Once i got it tested i'll assign point :)
Cheers
Ross
Cool, let me know if you need any further assistance. A friend of mine started another one a while ago called the EvilStapler but he got bored.