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 maintenance/backup question

Please lend some advice,

Right now we use a standard Database Maintenance Plan to backup and organize our SQL server databases. However we are running out of disk space because every night it does a full backup of the databases and a few of the databases are quite large > 1 GByte.

Is there a way to perform differential backups daily and full backups once a week (or month) in conjunction with a Database Maintenance Plan? I know how to schedule jobs and perform differential and full backups on this kind of schedule for a single database.

But I'm worried that creating separate jobs for each database to handle the full backup, the differential backup, the backup of the transaction log, compacting the database, (etc) is going to become a nightmare to keep up with 50+ jobs.

I like the Database Maintenance Plan because i can go to one place and manage the backup, reorganization, compacting, etc of all of our databases at once and schedule just a few jobs.

What is the best way to maintain (and especially backup) 10+ databases of decent size?

Thanks in advance,
Shane Kunklecheck google. There are plenty of site containing SQL Server administration tips... (ex: sswug.org)

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applications but don't do the SQL maintenance but do build db (my dba checks everything and sets all the permissions, etc). Anyway, a nonprofit has asked me to build them a web applicati
on to collect and display information nothing too fancy but lots of data and lot of users.
What are my options? Do I have to buy the server version if I just want to build a database but it is going to be collecting and serving the information from our web host (they've agreed to the extra cost for a web host providing SQL), we aren't keeping
a local version of the records. So I just need SQL to build the db and upload it to our web host. My dba said try access but it only allows 5 concurrent connections. I've heard of MySql or something but since I am somewhat familiar with the basics of
SQL was hoping there was some option for me. They don't need to do analysis or use the info other than to display it on web pages. They estimate they have 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
I appreciate any recommendations or advice you could provide.
Thanks!!
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David
|||Hi David
So if I bought the developer edition I would be legal to build the database and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:

> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> applications but don't do the SQL maintenance but do build db (my dba checks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display information
> nothing too fancy but lots of data and lot of users.
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MySql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or use
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>
|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
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
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.

> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/do...s/download.asp
David

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applications but don't do the SQL maintenance but do build db (my dba checks everything and sets all the permissions, etc). Anyway, a nonprofit has asked me to build them a web application to collect and display information nothing too fancy but lots of data and lot of users.
What are my options? Do I have to buy the server version if I just want to build a database but it is going to be collecting and serving the information from our web host (they've agreed to the extra cost for a web host providing SQL), we aren't keeping a local version of the records. So I just need SQL to build the db and upload it to our web host. My dba said try access but it only allows 5 concurrent connections. I've heard of MySql or something but since I am somewhat familiar with the basics of SQL was hoping there was some option for me. They don't need to do analysis or use the info other than to display it on web pages. They estimate they have 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
I appreciate any recommendations or advice you could provide.
Thanks!!"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David|||Hi David
So if I bought the developer edition I would be legal to build the database and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:
> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> > Hi All
> > At work we use SQL server to host all our databases. I develop web
> applications but don't do the SQL maintenance but do build db (my dba checks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display information
> nothing too fancy but lots of data and lot of users.
> > What are my options? Do I have to buy the server version if I just want
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MySql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or use
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> > I appreciate any recommendations or advice you could provide.
> > Thanks!!
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
--
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
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.
> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/downloads/download.asp
David

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applicat
ions but don't do the SQL maintenance but do build db (my dba checks everyth
ing and sets all the permissions, etc). Anyway, a nonprofit has asked me to
build them a web applicati
on to collect and display information nothing too fancy but lots of data and
lot of users.
What are my options? Do I have to buy the server version if I just want to
build a database but it is going to be collecting and serving the informatio
n from our web host (they've agreed to the extra cost for a web host providi
ng SQL), we aren't keeping
a local version of the records. So I just need SQL to build the db and uplo
ad it to our web host. My dba said try access but it only allows 5 concurr
ent connections. I've heard of mysql or something but since I am somewhat f
amiliar with the basics of
SQL was hoping there was some option for me. They don't need to do analysis
or use the info other than to display it on web pages. They estimate they
have 5,000 - 10,000 users who will enter 10 to 20 records each including pho
tos.
I appreciate any recommendations or advice you could provide.
Thanks!!"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David|||Hi David
So if I bought the developer edition I would be legal to build the database
and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I
go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:

> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> applications but don't do the SQL maintenance but do build db (my dba chec
ks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display informatio
n
> nothing too fancy but lots of data and lot of users.
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So
I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MyS
ql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or us
e
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos
.
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
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
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.

> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/d...ds/download.asp
David