I have a client, who is hosting our database. I have limited access to anything other than our database.
The SQL 2000 is running on Windows 2003 R2 Enterprise edition.
The client is trying to backup the transaction log using the Windows Native backup utility.
The Windows Native backup utility is not truncating the log, so the log is getting bigger and bigger.
My advice to the client was to allow me to create backup plans and write to a network location, this way the log would get truncated. Their answer is no.
I suggested a third party tool, and mentioned RedGate, Idera, and others. Again their response is no.
So, I have little experience with the native backup utility in Windows.
Can anyone suggest a way for the native utility to backup the log and truncate it?