Log explorer turned out to be the ticket towards finding out what my problem was (obtained an evaluation copy, now I'm going to have to get a...
ty for refs and the point about DTS bulging the logs... Sounds like if I redo the log shipping using stored procedures, and get rid of the shrink...
1. Can profiler be used to monitor what goes into the transaction log? Or is there a way to use profiler to look at the actual db activity and gauge...
How hard is it to create an excel file and dump data (nicely formatted) into it? tanstaafl
that being the case... can you change the directory where the data is stored to a share? or just grant the account that the agent uses access to it?...
My configuration has good news and bad news. Good news is my database is pretty small (~30 MB), using SQL Server 2000 Enterprise on both machines, I...
This may be a bit off-topic, not sure, but in regards to using the WAITFORDELAY... my log shipping implementation is done a bit differently (since my...
Separate names with a comma.