Backup error

Hello
I was told by email someone got an backup error and I gotta reply something
to him, what reasons can there be for this error? All services are running
and disk isnt full
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'Backup All Databases'' (0xE09A5EC5A9A4CE4C859FA208632D02D8) - Status:
Failed - Invoked on: 2006-02-17 00:00:00 - Message: The job failed. The Job
was invoked by Schedule 2 (Schedule 1). The last step to run was step 1
(Step 1).There has to be a more detailed error description, this one is telling
you nothing, Look at the particular step of this Maintanance job. As
the maintainance wiurad is creating jobs for all the work which is done
with him, there should be more error descriptions. See if the jobs have
a log purged out, can be found on one tab of the Job step.
HTH, Jens Suessmeyer.|||Jens,
I dont see a step in there, it all looks fine under Database Maintanence
Plans, it's a job that backs up all databases... not sure where to look
<Jens.Suessmeyer@.googlemail.com> wrote in message
news:1140164119.642261.146590@.z14g2000cwz.googlegroups.com...
> There has to be a more detailed error description, this one is telling
> you nothing, Look at the particular step of this Maintanance job. As
> the maintainance wiurad is creating jobs for all the work which is done
> with him, there should be more error descriptions. See if the jobs have
> a log purged out, can be found on one tab of the Job step.
> HTH, Jens Suessmeyer.
>|||Configure the maint plan to create a report file and check that report file
for the actual error
message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Lasse Edsvik" <lasse@.nospam.com> wrote in message news:OFWw7%235MGHA.2580@.TK2MSFTNGP14.phx
.gbl...
> Jens,
> I dont see a step in there, it all looks fine under Database Maintanence
> Plans, it's a job that backs up all databases... not sure where to look
>
> <Jens.Suessmeyer@.googlemail.com> wrote in message
> news:1140164119.642261.146590@.z14g2000cwz.googlegroups.com...
>

Backup

How do you back up the Agent Jobs and the Local Packages under Data
Transformation services? Does this get backed up when you back up the Master
database?
Thanks
RickThey get backed up when you backup the msdb database.
-Sue
On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
<rick@.di-wave.com> wrote:
>How do you back up the Agent Jobs and the Local Packages under Data
>Transformation services? Does this get backed up when you back up the Master
>database?
> Thanks
> Rick
>|||Thanks very much!!!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9ngljvsocne65i7n5lsftphqpddsqs579u@.4ax.com...
> They get backed up when you backup the msdb database.
> -Sue
> On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
> <rick@.di-wave.com> wrote:
> >How do you back up the Agent Jobs and the Local Packages under Data
> >Transformation services? Does this get backed up when you back up the
Master
> >database?
> >
> > Thanks
> > Rick
> >
>

Backing up the Services Master Key

What happens if you don't backup the Service Master Key, or don't know where
the backup is? Will this keep you from restoring the Master Database? How
does this backup play in the disaster recovery?Hi
"DBA GUY" wrote:
> What happens if you don't backup the Service Master Key, or don't know where
> the backup is? Will this keep you from restoring the Master Database? How
> does this backup play in the disaster recovery?
Check out
http://blogs.msdn.com/lcris/archive/2005/07/08/sql-server-2005-a-look-at-the-master-keys.aspx
and other posts on the blog. The absolute worse case will be that you won't
be able to access the encrypted data in any of your databases, but if you
know the passwords to the DMKs you can drop the SMK encryption and re-apply
it.
John

Backing up the Services Master Key

What happens if you don't backup the Service Master Key, or don't know where
the backup is? Will this keep you from restoring the Master Database? How
does this backup play in the disaster recovery?
Hi
"DBA GUY" wrote:

> What happens if you don't backup the Service Master Key, or don't know where
> the backup is? Will this keep you from restoring the Master Database? How
> does this backup play in the disaster recovery?
Check out
http://blogs.msdn.com/lcris/archive/2005/07/08/sql-server-2005-a-look-at-the-master-keys.aspx
and other posts on the blog. The absolute worse case will be that you won't
be able to access the encrypted data in any of your databases, but if you
know the passwords to the DMKs you can drop the SMK encryption and re-apply
it.
John

Backing up the Services Master Key

What happens if you don't backup the Service Master Key, or don't know where
the backup is? Will this keep you from restoring the Master Database? How
does this backup play in the disaster recovery?Hi
"DBA GUY" wrote:

> What happens if you don't backup the Service Master Key, or don't know whe
re
> the backup is? Will this keep you from restoring the Master Database? Ho
w
> does this backup play in the disaster recovery?
Check out
http://blogs.msdn.com/lcris/archive.../>
r-keys.aspx
and other posts on the blog. The absolute worse case will be that you won't
be able to access the encrypted data in any of your databases, but if you
know the passwords to the DMKs you can drop the SMK encryption and re-apply
it.
John