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 - 2004-02-13 : 08:12:00
|
| Avnish writes "Hi,I am working with a BPO Company where daily database transaction is very high.Daily 100000 records updated/added in to database.I always worried if my sql server fail due to any reason, how can i run other system with in few minutes temporary and resotre Main server.I have another server machine.currently we are copying MDF and LDF file manually every day to other machine. but in this case we have ready to use data, but one day old.Is there any solution by which we can restore data before one hours or less.please advice.thanks AVNISH KUAMR" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-13 : 09:54:59
|
| Have a look at transaction log baackupz==========================================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. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-13 : 10:07:53
|
| What version?What's you're recovery model?Full, Simple or Bulk-Logged?Brett8-) |
|
|
|
|
|
|
Database Backup Plan