Viewing 6 posts - 1 through 6 (of 6 total)
Sounds like your missing an earlier tran log or diff backup?
March 5, 2004 at 2:23 pm
Actually, DDL statements are logged. We just ran a test and monitored through log explorer. The creates, drops, everything was captured. Check out this header in BOL:
'
March 5, 2004 at 1:57 pm
October 7, 2003 at 7:14 am
I also use sqllitespeed. Very satisfied with the product.
September 30, 2003 at 6:54 am
BOL says you can:
sp_dropserver 'old_servername\instancename'
GO
sp_addserver 'new_servername\instancename',local
GO
Perhaps you should try it before re-installing. I was going to try it myself but I don't have permissions to rename boxes on our...
July 30, 2003 at 9:48 am
Viewing 6 posts - 1 through 6 (of 6 total)