Missing dll file: backups

Showing posts with label backups. Show all posts

Monday, March 26, 2012

Model backup failed

Good morning,
I am new to sql server and I have an issue with my backups.
So I set up these jobs:
Backup for System database:
Model, Master, MSDB DATABASE separately (every day at 22h)
Model, Master, MSDB log separately (every hour, between 5h-21h)
Backup for User Database
Database User (every day at 23h)
Database Log (every hour, between 02h-21h)
2 Plan Maintenance
Integrity Checks for all Database (System + User)
Optimization Job for all Database (System + User)
Why does my model backup and msdb log failed ? any idea?
Thanks
InaCan you post us the contents of your error log file please!
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> Good morning,
> I am new to sql server and I have an issue with my backups.
> So I set up these jobs:
> Backup for System database:
> Model, Master, MSDB DATABASE separately (every day at 22h)
> Model, Master, MSDB log separately (every hour, between 5h-21h)
> Backup for User Database
> Database User (every day at 23h)
> Database Log (every hour, between 02h-21h)
> 2 Plan Maintenance
> Integrity Checks for all Database (System + User)
> Optimization Job for all Database (System + User)
> Why does my model backup and msdb log failed ? any idea?
> Thanks
> Ina
>|||Immy wrote:
> Can you post us the contents of your error log file please!
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> > Good morning,
> >
> > I am new to sql server and I have an issue with my backups.
> >
> > So I set up these jobs:
> >
> > Backup for System database:
> >
> > Model, Master, MSDB DATABASE separately (every day at 22h)
> > Model, Master, MSDB log separately (every hour, between 5h-21h)
> >
> > Backup for User Database
> >
> > Database User (every day at 23h)
> > Database Log (every hour, between 02h-21h)
> >
> > 2 Plan Maintenance
> > Integrity Checks for all Database (System + User)
> > Optimization Job for all Database (System + User)
> >
> > Why does my model backup and msdb log failed ? any idea?
> >
> > Thanks
> >
> > Ina
> >
What is recovery model msdb database? If it is simple you log backup
will fail
For model database backup failure look in error log , it will have
detailed information about it.
Regards
Amish Shah|||"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> Good morning,
> I am new to sql server and I have an issue with my backups.
> So I set up these jobs:
> Backup for System database:
> Model, Master, MSDB DATABASE separately (every day at 22h)
> Model, Master, MSDB log separately (every hour, between 5h-21h)
> Backup for User Database
> Database User (every day at 23h)
> Database Log (every hour, between 02h-21h)
> 2 Plan Maintenance
> Integrity Checks for all Database (System + User)
> Optimization Job for all Database (System + User)
> Why does my model backup and msdb log failed ? any idea?
Beacuse they are in SIMPLE recovery mode and there's no need for a
logbackup.
The full should work fine though.
> Thanks
> Ina
>|||Hi,
What is the error you are getting?
First of all there is no need to backup the log for Model and Master
database; this is because we
are not supposed to do manipulations into these system databases.
Incase if you are getting errors in transaction log backup then verify the
recovery model for MSDB and Model databases.
For transaction log backup the recovery model should be either Bulk_logged
or Full.
Thanks
Hari
SQL Server MVP
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> Good morning,
> I am new to sql server and I have an issue with my backups.
> So I set up these jobs:
> Backup for System database:
> Model, Master, MSDB DATABASE separately (every day at 22h)
> Model, Master, MSDB log separately (every hour, between 5h-21h)
> Backup for User Database
> Database User (every day at 23h)
> Database Log (every hour, between 02h-21h)
> 2 Plan Maintenance
> Integrity Checks for all Database (System + User)
> Optimization Job for all Database (System + User)
> Why does my model backup and msdb log failed ? any idea?
> Thanks
> Ina
>|||Thanks guys.
It was because the MSDB Database was set up to simple instead of Full.
I changed it
but the model DB backup I do not know why it is failing
The job failed. The Job was invoked by Schedule 26 (Schedule 1). The
last step to run was step 1 (Step 1).
This is the job error I get.
Ina
I thing
Hari Prasad wrote:
> Hi,
> What is the error you are getting?
> First of all there is no need to backup the log for Model and Master
> database; this is because we
> are not supposed to do manipulations into these system databases.
> Incase if you are getting errors in transaction log backup then verify the
> recovery model for MSDB and Model databases.
> For transaction log backup the recovery model should be either Bulk_logged
> or Full.
> Thanks
> Hari
> SQL Server MVP
>
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> > Good morning,
> >
> > I am new to sql server and I have an issue with my backups.
> >
> > So I set up these jobs:
> >
> > Backup for System database:
> >
> > Model, Master, MSDB DATABASE separately (every day at 22h)
> > Model, Master, MSDB log separately (every hour, between 5h-21h)
> >
> > Backup for User Database
> >
> > Database User (every day at 23h)
> > Database Log (every hour, between 02h-21h)
> >
> > 2 Plan Maintenance
> > Integrity Checks for all Database (System + User)
> > Optimization Job for all Database (System + User)
> >
> > Why does my model backup and msdb log failed ? any idea?
> >
> > Thanks
> >
> > Ina
> >|||Specify a report file for the Maint Plan and check for the SQL Server errors in that report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155043376.504435.46880@.n13g2000cwa.googlegroups.com...
> Thanks guys.
> It was because the MSDB Database was set up to simple instead of Full.
> I changed it
> but the model DB backup I do not know why it is failing
> The job failed. The Job was invoked by Schedule 26 (Schedule 1). The
> last step to run was step 1 (Step 1).
> This is the job error I get.
> Ina
> I thing
> Hari Prasad wrote:
>> Hi,
>> What is the error you are getting?
>> First of all there is no need to backup the log for Model and Master
>> database; this is because we
>> are not supposed to do manipulations into these system databases.
>> Incase if you are getting errors in transaction log backup then verify the
>> recovery model for MSDB and Model databases.
>> For transaction log backup the recovery model should be either Bulk_logged
>> or Full.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "ina" <roberta.inalbon@.gmail.com> wrote in message
>> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
>> > Good morning,
>> >
>> > I am new to sql server and I have an issue with my backups.
>> >
>> > So I set up these jobs:
>> >
>> > Backup for System database:
>> >
>> > Model, Master, MSDB DATABASE separately (every day at 22h)
>> > Model, Master, MSDB log separately (every hour, between 5h-21h)
>> >
>> > Backup for User Database
>> >
>> > Database User (every day at 23h)
>> > Database Log (every hour, between 02h-21h)
>> >
>> > 2 Plan Maintenance
>> > Integrity Checks for all Database (System + User)
>> > Optimization Job for all Database (System + User)
>> >
>> > Why does my model backup and msdb log failed ? any idea?
>> >
>> > Thanks
>> >
>> > Ina
>> >
>|||Thank you all for this good advice I will check it.
Ina
Tibor Karaszi wrote:
> Specify a report file for the Maint Plan and check for the SQL Server errors in that report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1155043376.504435.46880@.n13g2000cwa.googlegroups.com...
> > Thanks guys.
> >
> > It was because the MSDB Database was set up to simple instead of Full.
> > I changed it
> > but the model DB backup I do not know why it is failing
> >
> > The job failed. The Job was invoked by Schedule 26 (Schedule 1). The
> > last step to run was step 1 (Step 1).
> >
> > This is the job error I get.
> >
> > Ina
> >
> > I thing
> > Hari Prasad wrote:
> >> Hi,
> >>
> >> What is the error you are getting?
> >>
> >> First of all there is no need to backup the log for Model and Master
> >> database; this is because we
> >> are not supposed to do manipulations into these system databases.
> >>
> >> Incase if you are getting errors in transaction log backup then verify the
> >> recovery model for MSDB and Model databases.
> >> For transaction log backup the recovery model should be either Bulk_logged
> >> or Full.
> >>
> >> Thanks
> >> Hari
> >> SQL Server MVP
> >>
> >>
> >> "ina" <roberta.inalbon@.gmail.com> wrote in message
> >> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> >> > Good morning,
> >> >
> >> > I am new to sql server and I have an issue with my backups.
> >> >
> >> > So I set up these jobs:
> >> >
> >> > Backup for System database:
> >> >
> >> > Model, Master, MSDB DATABASE separately (every day at 22h)
> >> > Model, Master, MSDB log separately (every hour, between 5h-21h)
> >> >
> >> > Backup for User Database
> >> >
> >> > Database User (every day at 23h)
> >> > Database Log (every hour, between 02h-21h)
> >> >
> >> > 2 Plan Maintenance
> >> > Integrity Checks for all Database (System + User)
> >> > Optimization Job for all Database (System + User)
> >> >
> >> > Why does my model backup and msdb log failed ? any idea?
> >> >
> >> > Thanks
> >> >
> >> > Ina
> >> >
> >

Model backup failed

Friday, March 23, 2012

MMC recovery

We recently lost our hard disk on disk c: It contained
Windows 2000 system files, but no SQL Server 7.0 files.
Our program files, data, and backups were on drive d:.
After rebuilding the W2K server, we ran regrebld.exe to
reestabish the W2K registry entries. We were able to
restart SQL Server and the Agent, but MMC (Microsoft
Management Console) will not start due to problems with
missing CLSIDs. We are able to access the database and
Agent info from remote MMCs, but not on the local server.
I don't see any option to reinstall/register MMC. Any
ideas of what to do?I found instmmc.exe on the installation disk. I'll try it
in the morning.
>--Original Message--
>We recently lost our hard disk on disk c: It contained
>Windows 2000 system files, but no SQL Server 7.0 files.
>Our program files, data, and backups were on drive d:.
>After rebuilding the W2K server, we ran regrebld.exe to
>reestabish the W2K registry entries. We were able to
>restart SQL Server and the Agent, but MMC (Microsoft
>Management Console) will not start due to problems with
>missing CLSIDs. We are able to access the database and
>Agent info from remote MMCs, but not on the local
server.
>I don't see any option to reinstall/register MMC. Any
>ideas of what to do?
>.
>

Friday, March 9, 2012

Missing something simple

I have a new sever for our "stage" systems. This box is also the box used
for all backups. I can't seem to establish it for use in a maintenance
plan? Says that the server/location doesn't exist. " Device Error or
Device Offline. "
Is there a permissions seting that Ihave to set on this new box, or is there
some other reason?
\\StageSQL2 is server
\Database Backups\TGISQL\Data\ is folder for all db's and the db will have
it's sub_folder.
any ideas?
Stephen,
Ensure the Windows domain user account that the SQL Server Agent service is
running under has the appropriate permissions to write the backup files to
the share on your remote backup server.
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>
|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default...b;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>
|||"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/default...b;en-us;555128
>
Thanks. I had to do what it said and then share the folder to get a backup
to actually work. Don't like the share idea but it's working for now.
|||You can always apply NTFS permissions to the underlying file structure and
restrict it down as tight as you like. The SQL service account will always
need FULL ACCESS, but you can deny anyone else access.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:%23HOFkMiuFHA.3752@.TK2MSFTNGP09.phx.gbl...
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Thanks. I had to do what it said and then share the folder to get a
> backup to actually work. Don't like the share idea but it's working for
> now.
>

Missing something simple

I have a new sever for our "stage" systems. This box is also the box used
for all backups. I can't seem to establish it for use in a maintenance
plan? Says that the server/location doesn't exist. " Device Error or
Device Offline. "
Is there a permissions seting that Ihave to set on this new box, or is there
some other reason?
\\StageSQL2 is server
\Database Backups\TGISQL\Data\ is folder for all db's and the db will have
it's sub_folder.
any ideas?Stephen,
Ensure the Windows domain user account that the SQL Server Agent service is
running under has the appropriate permissions to write the backup files to
the share on your remote backup server.
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/defaul...kb;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/defaul...kb;en-us;555128
>
Thanks. I had to do what it said and then share the folder to get a backup
to actually work. Don't like the share idea but it's working for now.|||You can always apply NTFS permissions to the underlying file structure and
restrict it down as tight as you like. The SQL service account will always
need FULL ACCESS, but you can deny anyone else access.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:%23HOFkMiuFHA.3752@.TK2MSFTNGP09.phx.gbl...
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Thanks. I had to do what it said and then share the folder to get a
> backup to actually work. Don't like the share idea but it's working for
> now.
>

Missing something simple

I have a new sever for our "stage" systems. This box is also the box used
for all backups. I can't seem to establish it for use in a maintenance
plan? Says that the server/location doesn't exist. " Device Error or
Device Offline. "
Is there a permissions seting that Ihave to set on this new box, or is there
some other reason?
\\StageSQL2 is server
\Database Backups\TGISQL\Data\ is folder for all db's and the db will have
it's sub_folder.
any ideas?Stephen,
Ensure the Windows domain user account that the SQL Server Agent service is
running under has the appropriate permissions to write the backup files to
the share on your remote backup server.
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
>
Thanks. I had to do what it said and then share the folder to get a backup
to actually work. Don't like the share idea but it's working for now.|||You can always apply NTFS permissions to the underlying file structure and
restrict it down as tight as you like. The SQL service account will always
need FULL ACCESS, but you can deny anyone else access.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:%23HOFkMiuFHA.3752@.TK2MSFTNGP09.phx.gbl...
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
>> HowTo: Backup to UNC name using Database Maintenance Wizard
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
> Thanks. I had to do what it said and then share the folder to get a
> backup to actually work. Don't like the share idea but it's working for
> now.
>

Monday, March 26, 2012

Model backup failed

Model backup failed

Friday, March 23, 2012

MMC recovery

Friday, March 9, 2012

Missing something simple

Missing something simple

Missing something simple

Missing dll file

Blog Archive

About Me