Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Windows 2003 R2 Native backup for sql2000 tranaction log. Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 8:50 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:35 AM
Points: 442, Visits: 801
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?

Thanks

Gary



Post #1460510
Posted Wednesday, June 5, 2013 10:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:56 PM
Points: 33,202, Visits: 15,348
AFAIK, the native Windows backup utility doesn't back up the SQL Server logs. You should use the SQL Server backup command (BACKUP LOG TO DISK) and then the Windows Backup utility can pick up that file.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1460515
Posted Wednesday, June 5, 2013 11:21 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:35 AM
Points: 442, Visits: 801
Steve, thanks for the reply.
That was my suspicion all along.

Gary




Post #1460522
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse