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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-21 : 08:11:10
|
| Anoop writes "HiiiPlease can tell me how to create an additional sql server for an existing one.The size of the database is below 3gb.My organization is an entertainment industry (Multiplex).we used to sell tickets for cinemas.We take backup twice in a day one in the night and the other one in the night.But the problem is Suppose the show is at 3:30pm and server crashed at 3:00pm but the backup avaliable is of yesterday night's,we will loose all our data for that movie that is sold from morning to 3:00pm. So we need something, that will provide the last transaction has made in the main server should be copied or send or replicated to the secondary server.I think you have understood what is my actual requirement please give the appropriate solution for my problem RegardsAnoop" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-21 : 09:08:52
|
| Take transaction log backups which will give you more restore options than you have at the moment - have a look in bol. Means setting the database to full or builk logged (If you aren't simple at the moment you can guarantee a crash and probable lost database at some point).You could also look at log shipping or replication.If the data isn't very complex (and I suspect it isn't) then you could just do a remote insert but this will make things slower.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
create an additional sql server for an existing one