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 Q setting up MSDE

Hello. I've installed MSDE (Win2k machine, running asp.net on localhost),
and it says 'Not Connected' when I mouseover the icon in the system tray. I
opened the SQL Server service manager, and there are two empty fields-
Server and Services. Please, what do I put in these fields? Also, what
connection string would I use with MSDE. Thanks a lot
Justin Dutoit
hi Justin,
"Justin Dutoit" <anon@.anon.com> ha scritto nel messaggio
news:%23Gr48BqqEHA.3988@.tk2msftngp13.phx.gbl
> Hello. I've installed MSDE (Win2k machine, running asp.net on
> localhost), and it says 'Not Connected' when I mouseover the icon in
> the system tray. I opened the SQL Server service manager, and there
> are two empty fields- Server and Services. Please, what do I put in
> these fields? Also, what connection string would I use with MSDE.
> Thanks a lot
> Justin Dutoit
please verify, using the services applet (control panel->performance and
maintenance->administrative tools->services [on XP] , control
panel->administrative tools->services [on Win2k]) that your MSDE instance is
currently up and running...
you can then try typing in the service name of your MSDE instance to manage
it...
MSDE installs by default disabling network protocols and this can be an
issue for some ODBC related functions and, sometime, the SQL Server
instances are not enlisted by the Service Manager, as reported in
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Newbie needs place to start

I am totally new to the BI world. I was just wondering where I should start to begin setting up a BI solution. I started trying to go through the Microsoft Anaylsis Services tutorial line for line in the MSDN website. I couldn't get the sample solution to work quite right. Should I be starting somewhere more simple to start. Please help, so far it looks a bit overwelming, especially with the terminology and examples I have seen so far from various sites about BI and Data Mining.

I think the virtual labs are a great place to start.

http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx

Each lab is 20 minutes and gives an overview of one or two technologies. Together they cover the whole BI space, and they all follow similar themes, so learning from one can work with another. Subjects include:

Business Intelligence: Building Integrated BI Solutions Leveraging SQL 2005 and Office 2007 Servers Business Intelligence: Using Business Scorecard Manager 2005 and ProClarity for Performance Management Business Intelligence: Excel 2007 PivotTables and Analysis Services Business Intelligence: Report Builder Business Intelligence: Integration Services Business Intelligence: Service Analysis Business Intelligence: Data Mining Business Intelligence: Business Scorecard Manager

Newbie Merge replication question

Hi!

I'm setting up a merge replication for sql ce. Ten guys with windows mobile 5 pocket pc works as service technicians and need to synchronize data in the field.

The backend database is huge and I just want each person to have their own data on the pda and synchronized, they have unique userid's in the database. Is it possible to filter data for each person or do all have to have all data that's in the backend database?

/Magnus

Merge replication permits the agents to have subsets of the data based on how the Publication is programmed. One alternate approach would be to publish individual agent tables, but this gets messy as agents are added and removed.|||Could I use a "translator" table to translate suser_name()'s to applications userid's? Then in the filter query against this table to identify the user? One solution could be to have one Publication for each employee? Yes it would become messy to administer. But my problem can't be unique. How do you all query out data for each employee?|||You could have each user identifying themselves when using the application, and setting their userid as HostName on your replication object. Then you can reference this in your publication filter with HOST_NAME().

Newbie Merge replication question

Hi!

I'm setting up a merge replication for sql ce. Ten guys with windows mobile 5 pocket pc works as service technicians and need to synchronize data in the field.

The backend database is huge and I just want each person to have their own data on the pda and synchronized, they have unique userid's in the database. Is it possible to filter data for each person or do all have to have all data that's in the backend database?

/Magnus

Merge replication permits the agents to have subsets of the data based on how the Publication is programmed. One alternate approach would be to publish individual agent tables, but this gets messy as agents are added and removed.|||Could I use a "translator" table to translate suser_name()'s to applications userid's? Then in the filter query against this table to identify the user? One solution could be to have one Publication for each employee? Yes it would become messy to administer. But my problem can't be unique. How do you all query out data for each employee?|||You could have each user identifying themselves when using the application, and setting their userid as HostName on your replication object. Then you can reference this in your publication filter with HOST_NAME().

Newbie BIDS questions

I've been learning SSIS and the BIDS for a few weeks now and there are 2 things that really annoy me. I'm hoping that there is a setting or option or something that I'm missing.

1. I place objects on the Control Flow surface, get everything arranged the way I want it, constraint lines all nice and tidy and then save it. When I open it things aren't the way they were when I closed it. Any way to make them stay the same?

2. If I select multiple objects and copy them when I paste them they are in really interesting places. Any way to have them stay in the same realitive positions?

This is one of the most helpful forums I've ever posted in so thanks to you all for the assistance.

John Colaizzi

John Colaizzi wrote:

I've been learning SSIS and the BIDS for a few weeks now and there are 2 things that really annoy me. I'm hoping that there is a setting or option or something that I'm missing.

1. I place objects on the Control Flow surface, get everything arranged the way I want it, constraint lines all nice and tidy and then save it. When I open it things aren't the way they were when I closed it. Any way to make them stay the same?

I cna't repro this problem. I admit when I open it the scrolling sometimes put me in a funny position but the objects are still in the same place in relation to each other. Fix the "scroleld to the wrong place" problem by going Edit-->Zoom-->To Fit.

John Colaizzi wrote:

2. If I select multiple objects and copy them when I paste them they are in really interesting places. Any way to have them stay in the same realitive positions?

Unfortunately not. Annoying isn't it?

John Colaizzi wrote:

This is one of the most helpful forums I've ever posted in so thanks to you all for the assistance.

John Colaizzi

|||

Jamie,

Are you saying that if you create a task, then create two more, drag constraint lines to each of the two more tasks, move the lines around, save and come back the lines are where you put them?

Here is a before:

and after:

It seems to happen mostly where I've changed anchor points or moved the lines so they don't cross directly over another object, especially a task.

Also, if I change an anchor point on the first object and then move the second object the lines redraw with the original anchor point. It almost seems pointless to move the lines at all :(

John

|||Did you ever find a fix for #1...? It's really annoying to organize my diagram only to have it revert back upon being closed and reopened...|||

I honestly don't ever find this to be a problem. Perhaps its because I always use the Auto-layout feature.

-Jamie

|||Unfortunately, my package is almost unreadable when 'auto arranged'... it's easy enough to arrange/move connections to improve it, but once I close and reopen the package it is all lost...

Newbie BIDS questions

I've been learning SSIS and the BIDS for a few weeks now and there are 2 things that really annoy me. I'm hoping that there is a setting or option or something that I'm missing.

1. I place objects on the Control Flow surface, get everything arranged the way I want it, constraint lines all nice and tidy and then save it. When I open it things aren't the way they were when I closed it. Any way to make them stay the same?

2. If I select multiple objects and copy them when I paste them they are in really interesting places. Any way to have them stay in the same realitive positions?

This is one of the most helpful forums I've ever posted in so thanks to you all for the assistance.

John Colaizzi

John Colaizzi wrote:

I've been learning SSIS and the BIDS for a few weeks now and there are 2 things that really annoy me. I'm hoping that there is a setting or option or something that I'm missing.

1. I place objects on the Control Flow surface, get everything arranged the way I want it, constraint lines all nice and tidy and then save it. When I open it things aren't the way they were when I closed it. Any way to make them stay the same?

I cna't repro this problem. I admit when I open it the scrolling sometimes put me in a funny position but the objects are still in the same place in relation to each other. Fix the "scroleld to the wrong place" problem by going Edit-->Zoom-->To Fit.

John Colaizzi wrote:

2. If I select multiple objects and copy them when I paste them they are in really interesting places. Any way to have them stay in the same realitive positions?

Unfortunately not. Annoying isn't it?

John Colaizzi wrote:

This is one of the most helpful forums I've ever posted in so thanks to you all for the assistance.

John Colaizzi

|||

Jamie,

Are you saying that if you create a task, then create two more, drag constraint lines to each of the two more tasks, move the lines around, save and come back the lines are where you put them?

Here is a before:

and after:

It seems to happen mostly where I've changed anchor points or moved the lines so they don't cross directly over another object, especially a task.

Also, if I change an anchor point on the first object and then move the second object the lines redraw with the original anchor point. It almost seems pointless to move the lines at all :(

John

|||Did you ever find a fix for #1...? It's really annoying to organize my diagram only to have it revert back upon being closed and reopened...|||

I honestly don't ever find this to be a problem. Perhaps its because I always use the Auto-layout feature.

-Jamie

|||Unfortunately, my package is almost unreadable when 'auto arranged'... it's easy enough to arrange/move connections to improve it, but once I close and reopen the package it is all lost...