Backups keep failing?

I used the database maintenance wizard and choose most of the defaults.
Every night my backups fail because of the step to check data indexes and
repair any minor problems. The error I receive is [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode. Does anyone know why this happeneds?
Thanks,
DanSee this page -
http://support.microsoft.com/default.aspx?scid=kb;en-us;290622
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Dan Marth" <danmarth@.earthlink.net> wrote in message
news:ux0ir6v2DHA.2408@.tk2msftngp13.phx.gbl...
> I used the database maintenance wizard and choose most of the defaults.
> Every night my backups fail because of the step to check data indexes and
> repair any minor problems. The error I receive is [Microsoft][ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs
to
> be in single user mode. Does anyone know why this happeneds?
> Thanks,
> Dan
>|||Thanks, that seemed to clear things up!
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:OTvHYUw2DHA.3196@.TK2MSFTNGP11.phx.gbl...
> See this page -
> http://support.microsoft.com/default.aspx?scid=kb;en-us;290622
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
> news:ux0ir6v2DHA.2408@.tk2msftngp13.phx.gbl...
> > I used the database maintenance wizard and choose most of the defaults.
> > Every night my backups fail because of the step to check data indexes
and
> > repair any minor problems. The error I receive is [Microsoft][ODBC SQL
> > Server Driver][SQL Server]Repair statement not processed. Database needs
> to
> > be in single user mode. Does anyone know why this happeneds?
> >
> > Thanks,
> > Dan
> >
> >
>

Backups keep failing?

I used the database maintenance wizard and choose most of the defaults.
Every night my backups fail because of the step to check data indexes and
repair any minor problems. The error I receive is [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode. Does anyone know why this happeneds?
Thanks,
DanSee this page -
http://support.microsoft.com/defaul...kb;en-us;290622
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Dan Marth" <danmarth@.earthlink.net> wrote in message
news:ux0ir6v2DHA.2408@.tk2msftngp13.phx.gbl...

quote:

---

> I used the database maintenance wizard and choose most of the defaults.
> Every night my backups fail because of the step to check data indexes and
> repair any minor problems. The error I receive is [Microsoft][ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs

---

to

quote:

---

> be in single user mode. Does anyone know why this happeneds?
> Thanks,
> Dan
>

---

|||Thanks, that seemed to clear things up!
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:OTvHYUw2DHA.3196@.TK2MSFTNGP11.phx.gbl...

quote:

---

> See this page -
> http://support.microsoft.com/defaul...kb;en-us;290622
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
> news:ux0ir6v2DHA.2408@.tk2msftngp13.phx.gbl...
and[QUOTE]
> to
>

---

Backups

I am using the maintenance plan wizard for Full backups and tlog backups. How do I include differential backups? Apparently I can't as part of the wizard, can I combine the current plan (full backups + tlog backups) thru the wizard and add a diff backup
seperately?
How to schedule them so that recovery would make sense?
Thanks
Yes you would simply create another job that does the diff backup... ( You
can acutally do this with the backup job Dialog box in SQL Enterprise
manager, then choose schedule.)
If you backup the whole db daily you might diff every 4 hours.. but most
folks will use diffs when they back the database up weekly... They'll do a
diff at the end of the business day, and perhaps another after nightly
batches...
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
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:EAF59FCE-E8ED-4C23-ACC8-4A089CD1815E@.microsoft.com...
> I am using the maintenance plan wizard for Full backups and tlog backups.
How do I include differential backups? Apparently I can't as part of the
wizard, can I combine the current plan (full backups + tlog backups) thru
the wizard and add a diff backup seperately?
> How to schedule them so that recovery would make sense?
> Thanks
>

Backups

I am using the maintenance plan wizard for Full backups and tlog backups. H
ow do I include differential backups? Apparently I can't as part of the wiz
ard, can I combine the current plan (full backups + tlog backups) thru the w
izard and add a diff backup
seperately?
How to schedule them so that recovery would make sense?
ThanksYes you would simply create another job that does the diff backup... ( You
can acutally do this with the backup job Dialog box in SQL Enterprise
manager, then choose schedule.)
If you backup the whole db daily you might diff every 4 hours.. but most
folks will use diffs when they back the database up weekly... They'll do a
diff at the end of the business day, and perhaps another after nightly
batches...
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
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:EAF59FCE-E8ED-4C23-ACC8-4A089CD1815E@.microsoft.com...
> I am using the maintenance plan wizard for Full backups and tlog backups.
How do I include differential backups? Apparently I can't as part of the
wizard, can I combine the current plan (full backups + tlog backups) thru
the wizard and add a diff backup seperately?
> How to schedule them so that recovery would make sense?
> Thanks
>

backups

Need to do sql server 2000 database and transaction log
backups. Using the backup wizard. Can back up on the
server machine no problem.
But I need to back up to another M/C which is visibly
connected by the network, and to a CD burner (which is
drive d on the server mc.) I have typed in a variety of
paths for each scenario and nothing is working.
Thank you
AnnAnn,
You need to use the UNC pattern.First create a share in that remote server,
make sure that the account under which SQL Server is running has the
required privileges/permissions on that share.After that, do the backup as:
BACKUP DATABASE <dbname>
TO DISK = '\\destserver\d$\dbbackup.BAK'
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"ann" <akukich@.plaind.com> wrote in message
news:025801c37d32$23687170$a101280a@.phx.gbl...
> Need to do sql server 2000 database and transaction log
> backups. Using the backup wizard. Can back up on the
> server machine no problem.
> But I need to back up to another M/C which is visibly
> connected by the network, and to a CD burner (which is
> drive d on the server mc.) I have typed in a variety of
> paths for each scenario and nothing is working.
> Thank you
> Ann|||Use the UNC paths. Example:
\\MachineName\ShareName
or
\\MachineName\Driver$\Folder1\Folder2
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"ann" <akukich@.plaind.com> wrote in message
news:025801c37d32$23687170$a101280a@.phx.gbl...
Need to do sql server 2000 database and transaction log
backups. Using the backup wizard. Can back up on the
server machine no problem.
But I need to back up to another M/C which is visibly
connected by the network, and to a CD burner (which is
drive d on the server mc.) I have typed in a variety of
paths for each scenario and nothing is working.
Thank you
Ann

Backup Wizard 2005 Standard

I have a new installation of SQL 2005 standard and I cannot create an
automatic backup. When I launch the wizard I get an error " Failed to
retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I ca
n
then create my backup job, but upon completion I get these 2 error:
Invalid column name 'from_msx'.
Invalid column name 'has_target'.
I have to manually launch the backups each night and that work fine. I
previously was using Sql 2000 and the backup jobs ran without any problems.On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> I have a new installation of SQL 2005 standard and I cannot create an
> automatic backup. When I launch the wizard I get an error " Failed to
> retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid colu
mn
> name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I
can
> then create my backup job, but upon completion I get these 2 error:
> Invalid column name 'from_msx'.
> Invalid column name 'has_target'.
> I have to manually launch the backups each night and that work fine. I
> previously was using Sql 2000 and the backup jobs ran without any problems.[/vbcol
]
Is this a server you upgraded to 2005 was a target server and prior to
upgrade did the server have master server?|||No this is a new Server not an upgrade. I moved the 2000 db over to this
server.
"Bulent" wrote:

> On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>

Backup Wizard 2005 Standard

I have a new installation of SQL 2005 standard and I cannot create an
automatic backup. When I launch the wizard I get an error " Failed to
retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
then create my backup job, but upon completion I get these 2 error:
Invalid column name 'from_msx'.
Invalid column name 'has_target'.
I have to manually launch the backups each night and that work fine. I
previously was using Sql 2000 and the backup jobs ran without any problems.On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> I have a new installation of SQL 2005 standard and I cannot create an
> automatic backup. When I launch the wizard I get an error " Failed to
> retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> then create my backup job, but upon completion I get these 2 error:
> Invalid column name 'from_msx'.
> Invalid column name 'has_target'.
> I have to manually launch the backups each night and that work fine. I
> previously was using Sql 2000 and the backup jobs ran without any problems.
Is this a server you upgraded to 2005 was a target server and prior to
upgrade did the server have master server?|||No this is a new Server not an upgrade. I moved the 2000 db over to this
server.
"Bulent" wrote:
> On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> > I have a new installation of SQL 2005 standard and I cannot create an
> > automatic backup. When I launch the wizard I get an error " Failed to
> > retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> > name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> > then create my backup job, but upon completion I get these 2 error:
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_target'.
> >
> > I have to manually launch the backups each night and that work fine. I
> > previously was using Sql 2000 and the backup jobs ran without any problems.
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>

Backup Wizard 2005 Standard

I have a new installation of SQL 2005 standard and I cannot create an
automatic backup. When I launch the wizard I get an error " Failed to
retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
then create my backup job, but upon completion I get these 2 error:
Invalid column name 'from_msx'.
Invalid column name 'has_target'.
I have to manually launch the backups each night and that work fine. I
previously was using Sql 2000 and the backup jobs ran without any problems.
On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> I have a new installation of SQL 2005 standard and I cannot create an
> automatic backup. When I launch the wizard I get an error " Failed to
> retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> then create my backup job, but upon completion I get these 2 error:
> Invalid column name 'from_msx'.
> Invalid column name 'has_target'.
> I have to manually launch the backups each night and that work fine. I
> previously was using Sql 2000 and the backup jobs ran without any problems.
Is this a server you upgraded to 2005 was a target server and prior to
upgrade did the server have master server?
|||No this is a new Server not an upgrade. I moved the 2000 db over to this
server.
"Bulent" wrote:

> On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>