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 |
|
lyealain
Starting Member
4 Posts |
 Posted - 2008-02-22 : 03:26:14
|
| hi.. how do i create a log entries with checkpoint for each transaction when accessing and updating the database? i want to recover the data if in case of emergency....anyway how do i check whether it has emergency? haha.. i got an idea of switching of the electricity.. hahaha how should i do?lyealain hong loon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-22 : 14:22:15
|
| You just need to use either BULK_LOGGED or FULL recovery model. Then in case of a data recovery scenario, you would run restores including restore log.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
lyealain
Starting Member
4 Posts |
Posted - 2008-02-24 : 09:18:35
|
| hi.. actually i got an assignment from my lecturer where we were asked to Create a sample of transaction and sample of log entries with checkpoint for accessing and updating the database for recover purposes by using the sqlserver..can u please enlighten me on this? how do i create a log and checkpoint.. i have check the sqlserver2005.. it has already got the log file and checkpoint done.. why i still need to create ?lyealain hong loon |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-02-24 : 10:39:37
|
It is called homework for a reason, right? You need to learn this so that some day, when you graduate, you can actually have the knowledge..
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-24 : 13:11:13
|
| I don't understand what the teacher wants you to do. What do you mean by log entries? Does he just want you to use a transaction?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
create log file whe updating database sqlserver200