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 |
|
REDDY
Starting Member
43 Posts |
 Posted - 2005-05-25 : 16:07:46
|
| HiWhile I was restoring a LOG with "STOPAT" command on a database I got the following errorThe log in this backup set contains minimally logged changes. Point-in-time recovery is inhibited. RESTORE will roll forward to end of logs without recovering the database.The Database is in BULK Logged mode on SQL server2000(svc pk 3)is it not possible to use "STOPAT" allways while restoring a LOG file??Any help would be greately appriciatedReddy |
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-05-28 : 10:39:36
|
| There are certain types of operations - such as bulk load - which render the log "less than useful" for point-in-time recovery. You gave it away with the BULK Logged Mode.Never use that option in a database that would ever require point-in-time recovery unless those (bulk load) operations are scheduled, and are followed by a full backup. |
 |
|
|
REDDY
Starting Member
43 Posts |
Posted - 2005-05-31 : 16:15:11
|
| Thank you verymuch for your input,What if,if I have a FULL recovery mode and have some Truncate statements within the LOG,won't it work for this situation also??Reddy |
|
|
|
|
|
|
Using "Stopat" while restoring the LOG file