Re: suitable plan for Log backup
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/12/04
- Next message: Wayne Snyder: "Re: DBCC ShrinkDatabase on large DB"
- Previous message: Wayne Snyder: "Re: sql server agent problem"
- In reply to: Aryan: "suitable plan for Log backup"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 12 Jul 2004 07:55:03 -0400
When deciding how often to back up the log, probably the main consideration
is risk... If the server burns completely up, you will have lost all the
transactions since the last log backup... To reduce the risk backup the log
more frequently, many people back the log up hourly, but I have backups as
frequently as every 10 minutes...
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Aryan" <Aryan@discussions.microsoft.com> wrote in message news:FF3EF101-93B0-4B64-852C-4C924501405B@microsoft.com... > Hi, > > I have a 2GB database and the size of log file is approximately 1.5GB. For backup, I have defined a maintenance plan for DB & Log files. Unfortunately, after backup the size of log file does not decrease. It is said that after log file backup, SQL server eliminate the inactive logs automatically. > What is the best plan for Backup in SQL server? I mean, a plan for backup of DB/Log files and also we can have a log file in a suitable size. > > Thanks in advance > > Aryan >
- Next message: Wayne Snyder: "Re: DBCC ShrinkDatabase on large DB"
- Previous message: Wayne Snyder: "Re: sql server agent problem"
- In reply to: Aryan: "suitable plan for Log backup"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
