We are running Small Business Server 2003 and using a SQL
database .. At some point in the setup of this, another
person apparently setup from 1 to 3 backup jobs .. the
problem is that there have been 3 backup jobs running
nightly and that 2 of the 3 are appending to the previous
backup.. this resulted in our hard drive filling up almost
to the crash point before we realized there was a
problem .. I don't know where to look for this ..
To recover space on the server we had deleted all of the
backups which are in the c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP folder...
I don't work with SQL much and this has become my problem
to fix .. any help would be appreciated
Thank you
LauraYou have to tell us how the backups are done. Are they happening from a
Maintenance plan job or plain BACKUP commands? You can find this by looking
at the job step.
Anyway, you have to use the WITH INIT option for the BACKUP command, if you
don't want to append.
Also, you should think about moving the database backups to a different
machine, to be able to recover from a failure on the SQL Server box.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"laura" <lauras@.microtechsystems.com> wrote in message
news:0a7601c48b78$202e7b30$a301280a@.phx.gbl...
We are running Small Business Server 2003 and using a SQL
database .. At some point in the setup of this, another
person apparently setup from 1 to 3 backup jobs .. the
problem is that there have been 3 backup jobs running
nightly and that 2 of the 3 are appending to the previous
backup.. this resulted in our hard drive filling up almost
to the crash point before we realized there was a
problem .. I don't know where to look for this ..
To recover space on the server we had deleted all of the
backups which are in the c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP folder...
I don't work with SQL much and this has become my problem
to fix .. any help would be appreciated
Thank you
Laura|||Thank you much for the reply..
As I said I do not work with SQL except to troubleshoot
when there is a problem that no one else is trying to
solve, but with your suggestion I did find out 1. What a
job step is
2. Where to look for this information under the
Management ->SQL Server Agent -> Jobs (at least I think I
am looking in the right place..
3. Now I will try to find why there are 4 Backup jobs
listed in this category..
Any other info you can send would be appreciated..
Again, Thank you
Laura
>--Original Message--
>You have to tell us how the backups are done. Are they
happening from a
>Maintenance plan job or plain BACKUP commands? You can
find this by looking
>at the job step.
>Anyway, you have to use the WITH INIT option for the
BACKUP command, if you
>don't want to append.
>Also, you should think about moving the database backups
to a different
>machine, to be able to recover from a failure on the SQL
Server box.
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"laura" <lauras@.microtechsystems.com> wrote in message
>news:0a7601c48b78$202e7b30$a301280a@.phx.gbl...
>We are running Small Business Server 2003 and using a SQL
>database .. At some point in the setup of this, another
>person apparently setup from 1 to 3 backup jobs .. the
>problem is that there have been 3 backup jobs running
>nightly and that 2 of the 3 are appending to the previous
>backup.. this resulted in our hard drive filling up almost
>to the crash point before we realized there was a
>problem .. I don't know where to look for this ..
>To recover space on the server we had deleted all of the
>backups which are in the c:\Program Files\Microsoft SQL
>Server\MSSQL\BACKUP folder...
>I don't work with SQL much and this has become my problem
>to fix .. any help would be appreciated
>Thank you
>Laura
>
>.
>sql
Showing posts with label serious. Show all posts
Showing posts with label serious. Show all posts
Thursday, March 22, 2012
Backup serious appending problem
We are running Small Business Server 2003 and using a SQL
database .. At some point in the setup of this, another
person apparently setup from 1 to 3 backup jobs .. the
problem is that there have been 3 backup jobs running
nightly and that 2 of the 3 are appending to the previous
backup.. this resulted in our hard drive filling up almost
to the crash point before we realized there was a
problem .. I don't know where to look for this ..
To recover space on the server we had deleted all of the
backups which are in the c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP folder...
I don't work with SQL much and this has become my problem
to fix .. any help would be appreciated
Thank you
Laura
You have to tell us how the backups are done. Are they happening from a
Maintenance plan job or plain BACKUP commands? You can find this by looking
at the job step.
Anyway, you have to use the WITH INIT option for the BACKUP command, if you
don't want to append.
Also, you should think about moving the database backups to a different
machine, to be able to recover from a failure on the SQL Server box.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"laura" <lauras@.microtechsystems.com> wrote in message
news:0a7601c48b78$202e7b30$a301280a@.phx.gbl...
We are running Small Business Server 2003 and using a SQL
database .. At some point in the setup of this, another
person apparently setup from 1 to 3 backup jobs .. the
problem is that there have been 3 backup jobs running
nightly and that 2 of the 3 are appending to the previous
backup.. this resulted in our hard drive filling up almost
to the crash point before we realized there was a
problem .. I don't know where to look for this ..
To recover space on the server we had deleted all of the
backups which are in the c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP folder...
I don't work with SQL much and this has become my problem
to fix .. any help would be appreciated
Thank you
Laura
|||Thank you much for the reply..
As I said I do not work with SQL except to troubleshoot
when there is a problem that no one else is trying to
solve, but with your suggestion I did find out 1. What a
job step is
2. Where to look for this information under the
Management ->SQL Server Agent -> Jobs (at least I think I
am looking in the right place..
3. Now I will try to find why there are 4 Backup jobs
listed in this category..
Any other info you can send would be appreciated..
Again, Thank you
Laura
>--Original Message--
>You have to tell us how the backups are done. Are they
happening from a
>Maintenance plan job or plain BACKUP commands? You can
find this by looking
>at the job step.
>Anyway, you have to use the WITH INIT option for the
BACKUP command, if you
>don't want to append.
>Also, you should think about moving the database backups
to a different
>machine, to be able to recover from a failure on the SQL
Server box.
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"laura" <lauras@.microtechsystems.com> wrote in message
>news:0a7601c48b78$202e7b30$a301280a@.phx.gbl...
>We are running Small Business Server 2003 and using a SQL
>database .. At some point in the setup of this, another
>person apparently setup from 1 to 3 backup jobs .. the
>problem is that there have been 3 backup jobs running
>nightly and that 2 of the 3 are appending to the previous
>backup.. this resulted in our hard drive filling up almost
>to the crash point before we realized there was a
>problem .. I don't know where to look for this ..
>To recover space on the server we had deleted all of the
>backups which are in the c:\Program Files\Microsoft SQL
>Server\MSSQL\BACKUP folder...
>I don't work with SQL much and this has become my problem
>to fix .. any help would be appreciated
>Thank you
>Laura
>
>.
>
database .. At some point in the setup of this, another
person apparently setup from 1 to 3 backup jobs .. the
problem is that there have been 3 backup jobs running
nightly and that 2 of the 3 are appending to the previous
backup.. this resulted in our hard drive filling up almost
to the crash point before we realized there was a
problem .. I don't know where to look for this ..
To recover space on the server we had deleted all of the
backups which are in the c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP folder...
I don't work with SQL much and this has become my problem
to fix .. any help would be appreciated
Thank you
Laura
You have to tell us how the backups are done. Are they happening from a
Maintenance plan job or plain BACKUP commands? You can find this by looking
at the job step.
Anyway, you have to use the WITH INIT option for the BACKUP command, if you
don't want to append.
Also, you should think about moving the database backups to a different
machine, to be able to recover from a failure on the SQL Server box.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"laura" <lauras@.microtechsystems.com> wrote in message
news:0a7601c48b78$202e7b30$a301280a@.phx.gbl...
We are running Small Business Server 2003 and using a SQL
database .. At some point in the setup of this, another
person apparently setup from 1 to 3 backup jobs .. the
problem is that there have been 3 backup jobs running
nightly and that 2 of the 3 are appending to the previous
backup.. this resulted in our hard drive filling up almost
to the crash point before we realized there was a
problem .. I don't know where to look for this ..
To recover space on the server we had deleted all of the
backups which are in the c:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP folder...
I don't work with SQL much and this has become my problem
to fix .. any help would be appreciated
Thank you
Laura
|||Thank you much for the reply..
As I said I do not work with SQL except to troubleshoot
when there is a problem that no one else is trying to
solve, but with your suggestion I did find out 1. What a
job step is
2. Where to look for this information under the
Management ->SQL Server Agent -> Jobs (at least I think I
am looking in the right place..
3. Now I will try to find why there are 4 Backup jobs
listed in this category..
Any other info you can send would be appreciated..
Again, Thank you
Laura
>--Original Message--
>You have to tell us how the backups are done. Are they
happening from a
>Maintenance plan job or plain BACKUP commands? You can
find this by looking
>at the job step.
>Anyway, you have to use the WITH INIT option for the
BACKUP command, if you
>don't want to append.
>Also, you should think about moving the database backups
to a different
>machine, to be able to recover from a failure on the SQL
Server box.
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"laura" <lauras@.microtechsystems.com> wrote in message
>news:0a7601c48b78$202e7b30$a301280a@.phx.gbl...
>We are running Small Business Server 2003 and using a SQL
>database .. At some point in the setup of this, another
>person apparently setup from 1 to 3 backup jobs .. the
>problem is that there have been 3 backup jobs running
>nightly and that 2 of the 3 are appending to the previous
>backup.. this resulted in our hard drive filling up almost
>to the crash point before we realized there was a
>problem .. I don't know where to look for this ..
>To recover space on the server we had deleted all of the
>backups which are in the c:\Program Files\Microsoft SQL
>Server\MSSQL\BACKUP folder...
>I don't work with SQL much and this has become my problem
>to fix .. any help would be appreciated
>Thank you
>Laura
>
>.
>
Saturday, February 25, 2012
Backup of Sql tables
I am a serious newbie. How do you backup only certain
tables in a database? Thank you.
Angela
There is no way to backup a set of files on a databases, unless these files
are on a different filegroup. So if you really want to do this you will
need a secondary filegroup where either the primary or secondary filegroup
contains the subset of tables you want to backup.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela
|||You export them. Using DTS, BCP or some other export method.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela
|||Thank you so much Tibor. That's what I thought but was
not sure. I will practice doing that and restoring
somewhere else to be sure. Thanks.
Angel
>--Original Message--
>You export them. Using DTS, BCP or some other export
method.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Angella Bennet" <anonymous@.discussions.microsoft.com>
wrote in message
>news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
>
>.
>
tables in a database? Thank you.
Angela
There is no way to backup a set of files on a databases, unless these files
are on a different filegroup. So if you really want to do this you will
need a secondary filegroup where either the primary or secondary filegroup
contains the subset of tables you want to backup.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela
|||You export them. Using DTS, BCP or some other export method.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela
|||Thank you so much Tibor. That's what I thought but was
not sure. I will practice doing that and restoring
somewhere else to be sure. Thanks.
Angel
>--Original Message--
>You export them. Using DTS, BCP or some other export
method.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Angella Bennet" <anonymous@.discussions.microsoft.com>
wrote in message
>news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
>
>.
>
Backup of Sql tables
I am a serious newbie. How do you backup only certain
tables in a database? Thank you.
AngelaThere is no way to backup a set of files on a databases, unless these files
are on a different filegroup. So if you really want to do this you will
need a secondary filegroup where either the primary or secondary filegroup
contains the subset of tables you want to backup.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||You export them. Using DTS, BCP or some other export method.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||Thank you so much Tibor. That's what I thought but was
not sure. I will practice doing that and restoring
somewhere else to be sure. Thanks.
Angel
>--Original Message--
>You export them. Using DTS, BCP or some other export
method.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Angella Bennet" <anonymous@.discussions.microsoft.com>
wrote in message
>news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
>
>.
>
tables in a database? Thank you.
AngelaThere is no way to backup a set of files on a databases, unless these files
are on a different filegroup. So if you really want to do this you will
need a secondary filegroup where either the primary or secondary filegroup
contains the subset of tables you want to backup.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||You export them. Using DTS, BCP or some other export method.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||Thank you so much Tibor. That's what I thought but was
not sure. I will practice doing that and restoring
somewhere else to be sure. Thanks.
Angel
>--Original Message--
>You export them. Using DTS, BCP or some other export
method.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Angella Bennet" <anonymous@.discussions.microsoft.com>
wrote in message
>news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
>
>.
>
Backup of Sql tables
I am a serious newbie. How do you backup only certain
tables in a database? Thank you.
AngelaThere is no way to backup a set of files on a databases, unless these files
are on a different filegroup. So if you really want to do this you will
need a secondary filegroup where either the primary or secondary filegroup
contains the subset of tables you want to backup.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||You export them. Using DTS, BCP or some other export method.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||Thank you so much Tibor. That's what I thought but was
not sure. I will practice doing that and restoring
somewhere else to be sure. Thanks.
Angel
>--Original Message--
>You export them. Using DTS, BCP or some other export
method.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Angella Bennet" <anonymous@.discussions.microsoft.com>
wrote in message
>news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
>> I am a serious newbie. How do you backup only certain
>> tables in a database? Thank you.
>> Angela
>
>.
>
tables in a database? Thank you.
AngelaThere is no way to backup a set of files on a databases, unless these files
are on a different filegroup. So if you really want to do this you will
need a secondary filegroup where either the primary or secondary filegroup
contains the subset of tables you want to backup.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||You export them. Using DTS, BCP or some other export method.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Angella Bennet" <anonymous@.discussions.microsoft.com> wrote in message
news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
> I am a serious newbie. How do you backup only certain
> tables in a database? Thank you.
> Angela|||Thank you so much Tibor. That's what I thought but was
not sure. I will practice doing that and restoring
somewhere else to be sure. Thanks.
Angel
>--Original Message--
>You export them. Using DTS, BCP or some other export
method.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Angella Bennet" <anonymous@.discussions.microsoft.com>
wrote in message
>news:f33d01c43db6$40db90d0$a601280a@.phx.gbl...
>> I am a serious newbie. How do you backup only certain
>> tables in a database? Thank you.
>> Angela
>
>.
>
Subscribe to:
Posts (Atom)