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 |
|
a_r_satish
Yak Posting Veteran
84 Posts |
 Posted - 2006-02-24 : 03:14:13
|
| Hi,I am new to the SQL server administration. i have the log file created and the transactions are maintained here.I jus want to know whether is there any option to alter the time of the transaction in the log file. In general i need the way to edit the log file.Thanks in advance.Regards,satish.r |
|
|
mallier
Starting Member
24 Posts |
Posted - 2006-02-24 : 06:34:09
|
| I didn't understand.why u want edit .ldf file.cheers,http://mallier.blogspot.com |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-02-24 : 08:42:03
|
| I also don't see a good reason for wanting to do this, and I do see a very BAD consequence: corrupting the log file and rendering it useless, possibly even the entire database. Even if you don't actually corrupt the log file, editing it may lose the ability to restore to a point-in-time. This is not something you want to attempt. |
|
|
|
a_r_satish
Yak Posting Veteran
84 Posts |
Posted - 2006-02-24 : 23:25:45
|
| As i said earlier, jus to change the date time for the transaction...I jus wanted to know whether is there any option or any other alternative..Thanks in advance.Regards,satish.rRegards,satish.r |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-02-25 : 01:46:58
|
| NoDamian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
Reg: Editing the ldf File