how backing up log files works

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

how backing up log files works

Author

Topic

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2012-01-24 : 02:49:57

I am now backing up log files every 15 minutes using code from
http://weblogs.sqlteam.com/tarad/archive/2008/06/30/SQL-Server-jobs-on-production-instances.aspx

now I see the issue is logs are getting backed up both to the directory I specified and

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

do I need both as it is using a lot of disk space?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-24 : 03:54:09

Tara's script won't back the logs up to 2 places, it'll just do it to the one location you specify. Make sure there isn't another log backup job somewhere.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources