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.
| Author |
Topic |
|
ksachinsoni
Starting Member
4 Posts |
 Posted - 2009-08-07 : 08:25:19
|
| friend our organisation have two offices in mumbai O1 and O2 the main database server(production) is in O1 i work in O2 so my manager said to have backup wid u. tht shud be daily back up or hourly? wat shud i do ? raplication or mirroring or somethng else? and O1 AND O2 about 10KM far from each other so manager told me to calculate if any cost wil requir there to set up? |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-07 : 09:02:08
|
quote:
Raplication
Definitely if that is an option!You could have your backups delivered by a fat man covered in oversize gold watches who arrives in a white stretch limo filled with his lady friends of negotiable disposition! Awesome!Seriously though:No real advise to give based on the info given. How big is the database? What are you doing to the database? do you need to be working with up to the second data? How much bandwidth between the two sites?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
ksachinsoni
Starting Member
4 Posts |
Posted - 2009-08-07 : 09:55:20
|
database size is 14 GB, and its a job portal, people submit thier profile so i just wanna knw thrs any option to have backup daily from my office, how wud i knw about the band width.quote:
Originally posted by Transact Charlie
quote:
Raplication
Definitely if that is an option!You could have your backups delivered by a fat man covered in oversize gold watches who arrives in a white stretch limo filled with his lady friends of negotiable disposition! Awesome!Seriously though:No real advise to give based on the info given. How big is the database? What are you doing to the database? do you need to be working with up to the second data? How much bandwidth between the two sites?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
|
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-07 : 20:18:12
|
| Either you or someone in your company's infrastructure department (if you have one) should know how quick the link between your 2 sites is (the bandwidth) and how much you pay for it (if you pay for it by use).what do you want to use your second database server for? Is it just so you can run ad hoc queries on? Or are you going to put some sort of application front end on it.Can you get away with just connecting remotely to the primary server with your app or other front end? 14G is going to be a bit of a pain to throw backups back and forth. Especially with encryption and decryption to protect the data.Can you give an indication of what you want to do with the second copy of the database? (in a little more depth)Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
ksachinsoni
Starting Member
4 Posts |
Posted - 2009-08-08 : 01:59:24
|
we jst wanna keep daily backup wid us bcos who knws wen the production server wil get cressed, and if we will have a copy of live database we can connect our test application with it and can test on it. hw do i knw about the bandwidth hw much it wud be to take daily backup of 14GB database.quote:
Originally posted by Transact Charlie
Either you or someone in your company's infrastructure department (if you have one) should know how quick the link between your 2 sites is (the bandwidth) and how much you pay for it (if you pay for it by use).what do you want to use your second database server for? Is it just so you can run ad hoc queries on? Or are you going to put some sort of application front end on it.Can you get away with just connecting remotely to the primary server with your app or other front end? 14G is going to be a bit of a pain to throw backups back and forth. Especially with encryption and decryption to protect the data.Can you give an indication of what you want to do with the second copy of the database? (in a little more depth)Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
|
|
|
|
|
|
|
|
|
Replication(high availability) and backup