If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
In a db designated full recovery mode wouldn't that be automatic when
taking a backup?
Thanks in advance.
GerryDataPro wrote:
Quote:
Originally Posted by
New to SQL Server. Running SQL Server 2000.
>
If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
>
In a db designated full recovery mode wouldn't that be automatic when
taking a backup?
I guess the wizard doesn't force you to use the options sensibly. :)|||
Quote:
Originally Posted by
>
I guess the wizard doesn't force you to use the options sensibly. :)
So I'm to assume that its doing a transaction log backup?|||DataPro (datapro01@.yahoo.com) writes:
Quote:
Originally Posted by
If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
>
In a db designated full recovery mode wouldn't that be automatic when
taking a backup?
No, you back up the transaction log independetly from the database.
It's a common mistake to run in full recovery but fail to take
transaction log backup. This leads to that the log keeps growing.
On the other hand, if you run simple recovery, you get forget all
about the transaction log.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Yes I was able to finally glean that from looking through a number of
manuals. Makes sense.....I guess it also makes sense not to assume
anything about SQL Server :)
Thanks much for the help.
Gerry
Erland Sommarskog wrote:
Quote:
Originally Posted by
DataPro (datapro01@.yahoo.com) writes:
Quote:
Originally Posted by
If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
In a db designated full recovery mode wouldn't that be automatic when
taking a backup?
>
No, you back up the transaction log independetly from the database.
It's a common mistake to run in full recovery but fail to take
transaction log backup. This leads to that the log keeps growing.
>
On the other hand, if you run simple recovery, you get forget all
about the transaction log.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"DataPro" <datapro01@.yahoo.comwrote in message
news:1158252255.146201.93870@.h48g2000cwc.googlegro ups.com...
Quote:
Originally Posted by
New to SQL Server. Running SQL Server 2000.
>
If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
>
Because you may want to run that at separate times.
For example, I do a full backup 3 nights a week and transaction log backups
every 20 minutes.
Quote:
Originally Posted by
In a db designated full recovery mode wouldn't that be automatic when
taking a backup?
No.
Quote:
Originally Posted by
>
Thanks in advance.
>
Gerry
>
news:1158255303.861188.53230@.d34g2000cwd.googlegro ups.com...
Quote:
Originally Posted by
>
Quote:
Originally Posted by
>>
>I guess the wizard doesn't force you to use the options sensibly. :)
>
So I'm to assume that its doing a transaction log backup?
>
Not unless you checked the box.
No comments:
Post a Comment