Newbie Question on DB Maintenance Plan

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?

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
>

|||"DataPro" <datapro01@.yahoo.comwrote in message
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.

Newbie question - how do I specify a variable for the file location when using the Execute Packa

There are two options to specify the subpackage location (SQL Server or file location). I'd like to know how I can specify a variable name that points to the file location so I avoid hard coding the file location which could change during production installation.
thanks

This is a start.
http://sqljunkies.com/WebLog/knight_reign/archive/2005/11/12/17375.aspx
Thanks,
K|||

To do this you must work on the file connection manager not on the task.

You go and add a property expression to Expression colection of the CM that would map your variable to the ConnectionString property of the CM.

Thanks,
Ovidiu

|||

Hi, I'm another newbie.

Can you give a short example of how to do that?

Thanks,

Roger

|||

Hi Ovidu,

Thanks for the reply. Yes, I am working in the connection manager. The problem I'm having is getting the connectionstring property to recognize a string variable. I've played with it a lot and the only syntx that I've tried that doesn't cause an error on entry is @.MyVariable. but, when I run the package, it is interpreted as a file name, which it doesn't find.

Tha variable is in scope. When I substitute a script task with a msgbox, I can step through the files. Can you show me a short example of how you'd do it?

Thanks, again,

Roger

Newbie question - how do I specify a variable for the file location when using the Execute Packa

There are two options to specify the subpackage location (SQL Server or file location). I'd like to know how I can specify a variable name that points to the file location so I avoid hard coding the file location which could change during production installation.
thanks

This is a start.
http://sqljunkies.com/WebLog/knight_reign/archive/2005/11/12/17375.aspx
Thanks,
K|||

To do this you must work on the file connection manager not on the task.

You go and add a property expression to Expression colection of the CM that would map your variable to the ConnectionString property of the CM.

Thanks,
Ovidiu

|||

Hi, I'm another newbie.

Can you give a short example of how to do that?

Thanks,

Roger

|||

Hi Ovidu,

Thanks for the reply. Yes, I am working in the connection manager. The problem I'm having is getting the connectionstring property to recognize a string variable. I've played with it a lot and the only syntx that I've tried that doesn't cause an error on entry is @.MyVariable. but, when I run the package, it is interpreted as a file name, which it doesn't find.

Tha variable is in scope. When I substitute a script task with a msgbox, I can step through the files. Can you show me a short example of how you'd do it?

Thanks, again,

Roger

sql