Hi! I have a big problem here...
I use SQL 7.0 SP4 and when the job for backup logs fails,
it send an email, as specified in the job, but only 1/2
times!!! The Net send message is sent correctly, but not
emails... Do someone know why or is experiencing this
problem?
Thanks
not sure what you mean half of the time...
first, make sure you have correctly setup email profile. Can you send a
test message via email?
"David" <david.parenteau@.compuware.com> wrote in message
news:16f1501c41819$fa018870$a301280a@.phx.gbl...
> Hi! I have a big problem here...
> I use SQL 7.0 SP4 and when the job for backup logs fails,
> it send an email, as specified in the job, but only 1/2
> times!!! The Net send message is sent correctly, but not
> emails... Do someone know why or is experiencing this
> problem?
>
> Thanks
>
|||yes, email are sent successfully when sent. By half of the
time I mean this:
I go to the Enterprise Managers, display the list of all
jobs in my SQL server. Right-click on a job and
choose "View Job History..."
The 5 most recent execution are failed. All executions has
sent NET SEND command. The first, third and fifth have
also sent an email notification. But not the second and
fourth!
Is it more clear?
Thanks
>--Original Message--
>not sure what you mean half of the time...
>first, make sure you have correctly setup email profile.
Can you send a
>test message via email?
>"David" <david.parenteau@.compuware.com> wrote in message
>news:16f1501c41819$fa018870$a301280a@.phx.gbl...
fails,
>
>.
>
|||the 5 executions are for the same job? they were executed
by the same user?
>--Original Message--
>yes, email are sent successfully when sent. By half of
the
>time I mean this:
>I go to the Enterprise Managers, display the list of all
>jobs in my SQL server. Right-click on a job and
>choose "View Job History..."
>The 5 most recent execution are failed. All executions
has
>sent NET SEND command. The first, third and fifth have
>also sent an email notification. But not the second and
>fourth!
>Is it more clear?
>Thanks
profile.
>Can you send a
>fails,
1/2
not
>.
>
|||Yes. These jobs were created by the Maintenance Plan
wizard and updated manually to set notification custom.
The first failure (and the others too) was due to a non
logged transactions (SELECT INTO). RIght now the problem
of failing is resolved, but the random problem of sending
email is not: "NOTE: Failed to notify 'teamSQLAdmin' via
email." was the reason of failed where no email was sent.
This job occurs every hours.
All emails marked as sent have been received normall in
the inbox.
David
>--Original Message--
>the 5 executions are for the same job? they were executed
>by the same user?
>the
>has
>profile.
>1/2
>not
>.
>
|||David,
Are you using MS Exchange Server? Perhaps there are exchange server outages periodically? Could you check with your exchange server admin team?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
|||Mark, yes, we use MS Exchange Server to send emails. The
mail server is dedicated on another server on the domain.
No outages are known for the mail server...
What this could involved?
>--Original Message--
>David,
>Are you using MS Exchange Server? Perhaps there are
exchange server outages periodically? Could you check with
your exchange server admin team?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>.
>
Showing posts with label backup. Show all posts
Showing posts with label backup. Show all posts
Wednesday, March 21, 2012
Email sent half of the time...
Hi! I have a big problem here...
I use SQL 7.0 SP4 and when the job for backup logs fails,
it send an email, as specified in the job, but only 1/2
times!!! The Net send message is sent correctly, but not
emails... Do someone know why or is experiencing this
problem?
Thanksnot sure what you mean half of the time...
first, make sure you have correctly setup email profile. Can you send a
test message via email?
"David" <david.parenteau@.compuware.com> wrote in message
news:16f1501c41819$fa018870$a301280a@.phx
.gbl...
> Hi! I have a big problem here...
> I use SQL 7.0 SP4 and when the job for backup logs fails,
> it send an email, as specified in the job, but only 1/2
> times!!! The Net send message is sent correctly, but not
> emails... Do someone know why or is experiencing this
> problem?
>
> Thanks
>|||yes, email are sent successfully when sent. By half of the
time I mean this:
I go to the Enterprise Managers, display the list of all
jobs in my SQL server. Right-click on a job and
choose "View Job History..."
The 5 most recent execution are failed. All executions has
sent NET SEND command. The first, third and fifth have
also sent an email notification. But not the second and
fourth!
Is it more clear?
Thanks
>--Original Message--
>not sure what you mean half of the time...
>first, make sure you have correctly setup email profile.
Can you send a
>test message via email?
>"David" <david.parenteau@.compuware.com> wrote in message
> news:16f1501c41819$fa018870$a301280a@.phx
.gbl...
fails,
>
>.
>|||the 5 executions are for the same job? they were executed
by the same user?
>--Original Message--
>yes, email are sent successfully when sent. By half of
the
>time I mean this:
>I go to the Enterprise Managers, display the list of all
>jobs in my SQL server. Right-click on a job and
>choose "View Job History..."
>The 5 most recent execution are failed. All executions
has
>sent NET SEND command. The first, third and fifth have
>also sent an email notification. But not the second and
>fourth!
>Is it more clear?
>Thanks
>
profile.
>Can you send a
>fails,
1/2
not
>.
>|||Yes. These jobs were created by the Maintenance Plan
wizard and updated manually to set notification custom.
The first failure (and the others too) was due to a non
logged transactions (SELECT INTO). RIght now the problem
of failing is resolved, but the random problem of sending
email is not: "NOTE: Failed to notify 'teamSQLAdmin' via
email." was the reason of failed where no email was sent.
This job occurs every hours.
All emails marked as sent have been received normall in
the inbox.
David
>--Original Message--
>the 5 executions are for the same job? they were executed
>by the same user?
>
>the
>has
>profile.
>1/2
>not
>.
>|||David,
Are you using MS Exchange Server? Perhaps there are exchange server outages
periodically? Could you check with your exchange server admin team?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Mark, yes, we use MS Exchange Server to send emails. The
mail server is dedicated on another server on the domain.
No outages are known for the mail server...
What this could involved?
>--Original Message--
>David,
>Are you using MS Exchange Server? Perhaps there are
exchange server outages periodically? Could you check with
your exchange server admin team?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>.
>
I use SQL 7.0 SP4 and when the job for backup logs fails,
it send an email, as specified in the job, but only 1/2
times!!! The Net send message is sent correctly, but not
emails... Do someone know why or is experiencing this
problem?
Thanksnot sure what you mean half of the time...
first, make sure you have correctly setup email profile. Can you send a
test message via email?
"David" <david.parenteau@.compuware.com> wrote in message
news:16f1501c41819$fa018870$a301280a@.phx
.gbl...
> Hi! I have a big problem here...
> I use SQL 7.0 SP4 and when the job for backup logs fails,
> it send an email, as specified in the job, but only 1/2
> times!!! The Net send message is sent correctly, but not
> emails... Do someone know why or is experiencing this
> problem?
>
> Thanks
>|||yes, email are sent successfully when sent. By half of the
time I mean this:
I go to the Enterprise Managers, display the list of all
jobs in my SQL server. Right-click on a job and
choose "View Job History..."
The 5 most recent execution are failed. All executions has
sent NET SEND command. The first, third and fifth have
also sent an email notification. But not the second and
fourth!
Is it more clear?
Thanks
>--Original Message--
>not sure what you mean half of the time...
>first, make sure you have correctly setup email profile.
Can you send a
>test message via email?
>"David" <david.parenteau@.compuware.com> wrote in message
> news:16f1501c41819$fa018870$a301280a@.phx
.gbl...
fails,
>
>.
>|||the 5 executions are for the same job? they were executed
by the same user?
>--Original Message--
>yes, email are sent successfully when sent. By half of
the
>time I mean this:
>I go to the Enterprise Managers, display the list of all
>jobs in my SQL server. Right-click on a job and
>choose "View Job History..."
>The 5 most recent execution are failed. All executions
has
>sent NET SEND command. The first, third and fifth have
>also sent an email notification. But not the second and
>fourth!
>Is it more clear?
>Thanks
>
profile.
>Can you send a
>fails,
1/2
not
>.
>|||Yes. These jobs were created by the Maintenance Plan
wizard and updated manually to set notification custom.
The first failure (and the others too) was due to a non
logged transactions (SELECT INTO). RIght now the problem
of failing is resolved, but the random problem of sending
email is not: "NOTE: Failed to notify 'teamSQLAdmin' via
email." was the reason of failed where no email was sent.
This job occurs every hours.
All emails marked as sent have been received normall in
the inbox.
David
>--Original Message--
>the 5 executions are for the same job? they were executed
>by the same user?
>
>the
>has
>profile.
>1/2
>not
>.
>|||David,
Are you using MS Exchange Server? Perhaps there are exchange server outages
periodically? Could you check with your exchange server admin team?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Mark, yes, we use MS Exchange Server to send emails. The
mail server is dedicated on another server on the domain.
No outages are known for the mail server...
What this could involved?
>--Original Message--
>David,
>Are you using MS Exchange Server? Perhaps there are
exchange server outages periodically? Could you check with
your exchange server admin team?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>.
>
Monday, March 19, 2012
e-mail notifications
Hi!
I'm a beginner in SQL Server. Sorry in this a stupid question but I dont have a clue.
I'm sending an e-mail when a backup ends and I want to know how can I change the subject and the body text of this notifications.
Is that possible? How can I do it?
Thanx in advance!is this backup a scheduled job? is there anyway for you to know how this backup is being done? using a DTS package??|||Yes, is a scheduled job. Why? Is this a problem?
Is better to use a DTS package? I haven't worked with this before...|||You can add a step in the job that uses xp_sendmail - passing the subject/body you want.|||Originally posted by rnealejr
You can add a step in the job that uses xp_sendmail - passing the subject/body you want.
because the backup is a job it uses the SQL server agent mail system, which is different from SQL Mail. by setting up the operator to get a msg you are useing the SQL Sever Agent mail system, which is very limited. To get greater flexability you need to use SQL mail, and the only way to get access to that is to use the xp_sendmail procedure in connection with a DTS package.
Jim|||Jim,
You don't need to use a dts package - you can run xp_sendmail within a step.|||Originally posted by rnealejr
Jim,
You don't need to use a dts package - you can run xp_sendmail within a step.
Very true didnt even think about that
Jim|||THANK YOU ALL!!
I'm going to try that way. I hope this works... :-\
I'm a beginner in SQL Server. Sorry in this a stupid question but I dont have a clue.
I'm sending an e-mail when a backup ends and I want to know how can I change the subject and the body text of this notifications.
Is that possible? How can I do it?
Thanx in advance!is this backup a scheduled job? is there anyway for you to know how this backup is being done? using a DTS package??|||Yes, is a scheduled job. Why? Is this a problem?
Is better to use a DTS package? I haven't worked with this before...|||You can add a step in the job that uses xp_sendmail - passing the subject/body you want.|||Originally posted by rnealejr
You can add a step in the job that uses xp_sendmail - passing the subject/body you want.
because the backup is a job it uses the SQL server agent mail system, which is different from SQL Mail. by setting up the operator to get a msg you are useing the SQL Sever Agent mail system, which is very limited. To get greater flexability you need to use SQL mail, and the only way to get access to that is to use the xp_sendmail procedure in connection with a DTS package.
Jim|||Jim,
You don't need to use a dts package - you can run xp_sendmail within a step.|||Originally posted by rnealejr
Jim,
You don't need to use a dts package - you can run xp_sendmail within a step.
Very true didnt even think about that
Jim|||THANK YOU ALL!!
I'm going to try that way. I hope this works... :-\
Sunday, March 11, 2012
Email Alert in SQL Server2000
can somebody help me to setup email alerts in SQL Server 2000 standard edition whenever, backup is successful OR failed to complete.
Thanks,
I'll assume you're doing scheduled backups via SQL Server Agent
1. Configure SQL Server to use SQL Mail (Check Books Online SQL Mail)
2. Add an operator to SQL Server Agent with the relevant email address
3. In your SQL Job, notifications tab, check the box to email, select your operator and also selec to alert whenever the job completes.
HTH!
Friday, March 9, 2012
EM VS TSQL
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
On Wed, 29 Sep 2004 10:03:24 +0530, uppal wrote:
Hi uppal,
Already answered in microsoft.public.sqlserver.server. Please post a
question to one newsgroup only. And if you really feel that you must post
to multiple groups, then at least use the cross-posting feature of your
newsreader.
http://www.aspfaq.com/etiquette.asp?id=5003
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
On Wed, 29 Sep 2004 10:03:24 +0530, uppal wrote:
Hi uppal,
Already answered in microsoft.public.sqlserver.server. Please post a
question to one newsgroup only. And if you really feel that you must post
to multiple groups, then at least use the cross-posting feature of your
newsreader.
http://www.aspfaq.com/etiquette.asp?id=5003
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
EM VS TSQL
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
See if this helps:
http://vyaskn.tripod.com/sql_enterpr...r_or_t-sql.htm
Also check the BACKUP and RESTORE commands in SQL Server Books Online.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
|||On Wed, 29 Sep 2004 10:02:55 +0530, uppal wrote:
>Please tell me that is it not recommended to use Enterprise manager for all
>operations?
Hi Uppal,
On the contrary. EM is very suitable for *SOME* operations. Just don't use
EM for creation of tables, views, procuderes and functions or for changing
data in your tables. Using EM to manage your SQL Server installation is
okay.
>Is it OK if i use EM for all backup , restore & Maintenance Plan?
That's one of the operations that EM excels in.
>Could you please provide me the TSQL for Backup , Restore & Maintenance
>Plan.
I have no idea. If you really need to know it, you should either look in
Books Online or you could run a trace to find out which commands are
executed when you execute these operations through EM.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> We are using SQL 2000
> Please tell me that is it not recommended to use Enterprise manager for
all
> operations?
> Is it OK if i use EM for all backup , restore & Maintenance Plan?
>
Control.
It all comes down to how much control you want.
> Could you please provide me the TSQL for Backup , Restore & Maintenance
> Plan.
> Thanking you in anticipation
> regards
>
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
See if this helps:
http://vyaskn.tripod.com/sql_enterpr...r_or_t-sql.htm
Also check the BACKUP and RESTORE commands in SQL Server Books Online.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards
|||On Wed, 29 Sep 2004 10:02:55 +0530, uppal wrote:
>Please tell me that is it not recommended to use Enterprise manager for all
>operations?
Hi Uppal,
On the contrary. EM is very suitable for *SOME* operations. Just don't use
EM for creation of tables, views, procuderes and functions or for changing
data in your tables. Using EM to manage your SQL Server installation is
okay.
>Is it OK if i use EM for all backup , restore & Maintenance Plan?
That's one of the operations that EM excels in.
>Could you please provide me the TSQL for Backup , Restore & Maintenance
>Plan.
I have no idea. If you really need to know it, you should either look in
Books Online or you could run a trace to find out which commands are
executed when you execute these operations through EM.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> We are using SQL 2000
> Please tell me that is it not recommended to use Enterprise manager for
all
> operations?
> Is it OK if i use EM for all backup , restore & Maintenance Plan?
>
Control.
It all comes down to how much control you want.
> Could you please provide me the TSQL for Backup , Restore & Maintenance
> Plan.
> Thanking you in anticipation
> regards
>
EM VS TSQL
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regardsSee if this helps:
http://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
Also check the BACKUP and RESTORE commands in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards|||On Wed, 29 Sep 2004 10:02:55 +0530, uppal wrote:
>Please tell me that is it not recommended to use Enterprise manager for all
>operations?
Hi Uppal,
On the contrary. EM is very suitable for *SOME* operations. Just don't use
EM for creation of tables, views, procuderes and functions or for changing
data in your tables. Using EM to manage your SQL Server installation is
okay.
>Is it OK if i use EM for all backup , restore & Maintenance Plan?
That's one of the operations that EM excels in.
>Could you please provide me the TSQL for Backup , Restore & Maintenance
>Plan.
I have no idea. If you really need to know it, you should either look in
Books Online or you could run a trace to find out which commands are
executed when you execute these operations through EM.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> We are using SQL 2000
> Please tell me that is it not recommended to use Enterprise manager for
all
> operations?
> Is it OK if i use EM for all backup , restore & Maintenance Plan?
>
Control.
It all comes down to how much control you want.
> Could you please provide me the TSQL for Backup , Restore & Maintenance
> Plan.
> Thanking you in anticipation
> regards
>
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regardsSee if this helps:
http://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
Also check the BACKUP and RESTORE commands in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
We are using SQL 2000
Please tell me that is it not recommended to use Enterprise manager for all
operations?
Is it OK if i use EM for all backup , restore & Maintenance Plan?
Could you please provide me the TSQL for Backup , Restore & Maintenance
Plan.
Thanking you in anticipation
regards|||On Wed, 29 Sep 2004 10:02:55 +0530, uppal wrote:
>Please tell me that is it not recommended to use Enterprise manager for all
>operations?
Hi Uppal,
On the contrary. EM is very suitable for *SOME* operations. Just don't use
EM for creation of tables, views, procuderes and functions or for changing
data in your tables. Using EM to manage your SQL Server installation is
okay.
>Is it OK if i use EM for all backup , restore & Maintenance Plan?
That's one of the operations that EM excels in.
>Could you please provide me the TSQL for Backup , Restore & Maintenance
>Plan.
I have no idea. If you really need to know it, you should either look in
Books Online or you could run a trace to find out which commands are
executed when you execute these operations through EM.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||"uppal" <compaq@.smil.co.in> wrote in message
news:eZItzydpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> We are using SQL 2000
> Please tell me that is it not recommended to use Enterprise manager for
all
> operations?
> Is it OK if i use EM for all backup , restore & Maintenance Plan?
>
Control.
It all comes down to how much control you want.
> Could you please provide me the TSQL for Backup , Restore & Maintenance
> Plan.
> Thanking you in anticipation
> regards
>
Sunday, February 26, 2012
Elusive Backup Process
Howdy Folks,
I have recently taken over looking after this machine & the previous guardian is unavailable. I've got to a point where I'm starting to think about looking into MSDB, but am not overly keen to start reviewing this db for obvious reasons... Can anyone please offer advise ?
Thank In Advance
Suze.
Environment: Microsoft SQL Server 2000 - 8.00.760 (sp3) on Win2000
H/W Dell PowerEdge 2550
Issue: Discovered in the sql log that there is a second set of bkps occurring around 7:30am - the bkps we have setup, run at 2am & are also being logged to sql log as completing normally.
The 7:30am bkps appear to be backing up to a remote location using pipes... or at a guess an agent ?? (I don't know know what that looks like cos we don't use agents). We backup db's to disk and then let arcserve pick up those backup files later.
I assume that this has been occurring for some time, sql logs back to July 7 advise so... Unable to locate scheduled job / maintenance plan that runs at this time...
Last night I set up a trace to catch it but that hasn't helped me either, apart from telling me that its an internal process to the server, and that the process actually started at 6:50am.
SQL LOGS Entries between midnight & 8am in attached file:
Trace contents in attached zip file:Someone had the sql agent installed on this server previously. It appears that the NT backup person still had it selected in the backup as well as the backups to disk. We have now removed this & shall wait and see tonight but I guess I now know what a remote agent arcserve backup looks like.
Cheers
I have recently taken over looking after this machine & the previous guardian is unavailable. I've got to a point where I'm starting to think about looking into MSDB, but am not overly keen to start reviewing this db for obvious reasons... Can anyone please offer advise ?
Thank In Advance
Suze.
Environment: Microsoft SQL Server 2000 - 8.00.760 (sp3) on Win2000
H/W Dell PowerEdge 2550
Issue: Discovered in the sql log that there is a second set of bkps occurring around 7:30am - the bkps we have setup, run at 2am & are also being logged to sql log as completing normally.
The 7:30am bkps appear to be backing up to a remote location using pipes... or at a guess an agent ?? (I don't know know what that looks like cos we don't use agents). We backup db's to disk and then let arcserve pick up those backup files later.
I assume that this has been occurring for some time, sql logs back to July 7 advise so... Unable to locate scheduled job / maintenance plan that runs at this time...
Last night I set up a trace to catch it but that hasn't helped me either, apart from telling me that its an internal process to the server, and that the process actually started at 6:50am.
SQL LOGS Entries between midnight & 8am in attached file:
Trace contents in attached zip file:Someone had the sql agent installed on this server previously. It appears that the NT backup person still had it selected in the backup as well as the backups to disk. We have now removed this & shall wait and see tonight but I guess I now know what a remote agent arcserve backup looks like.
Cheers
Friday, February 24, 2012
Ejecting Tape automatically after Backup
I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out
of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/e...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
>
out of[vbcol=seagreen]
Database[vbcol=seagreen]
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out
of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/e...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
>
out of[vbcol=seagreen]
Database[vbcol=seagreen]
Sunday, February 19, 2012
Ejecting Tape automatically after Backup
I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out
of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/e...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
>
out of[vbcol=seagreen]
Database[vbcol=seagreen]
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out
of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/e...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
>
out of[vbcol=seagreen]
Database[vbcol=seagreen]
Ejecting Tape automatically after Backup
I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me?
Thanks
Satyaki
satyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me?
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.
|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>
|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/en...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
out of[vbcol=seagreen]
Database[vbcol=seagreen]
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me?
Thanks
Satyaki
satyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me?
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.
|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>
|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/en...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
out of[vbcol=seagreen]
Database[vbcol=seagreen]
Ejecting Tape automatically after Backup
I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> > I had configured a Database Maintenance task for performing daily full
> > database backup into tape drive and it is working fine.
> >
> > My problem is after performing the backup it is not ejecting the tape out of
> > the drive automatically. Also there is no option available in the Database
> > Maintenace Wizard to configure same.
> >
> > Can any body help me'
> >
> > Thanks
> > Satyaki
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ba-bz_35ww.asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
> > satyaki wrote:
> > > I had configured a Database Maintenance task for performing daily full
> > > database backup into tape drive and it is working fine.
> > >
> > > My problem is after performing the backup it is not ejecting the tape
out of
> > > the drive automatically. Also there is no option available in the
Database
> > > Maintenace Wizard to configure same.
> > >
> > > Can any body help me'
> > >
> > > Thanks
> > > Satyaki
> >
> > Just a suggestion, we leave the tapes in the drive as it shows that the
> > tape did not run out of space. When a tape is full, it ejects so you
> > can put another in - and the person changing the tapes immediately knows
> > something is wrong.
> >
> >
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> > I had configured a Database Maintenance task for performing daily full
> > database backup into tape drive and it is working fine.
> >
> > My problem is after performing the backup it is not ejecting the tape out of
> > the drive automatically. Also there is no option available in the Database
> > Maintenace Wizard to configure same.
> >
> > Can any body help me'
> >
> > Thanks
> > Satyaki
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ba-bz_35ww.asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
> > satyaki wrote:
> > > I had configured a Database Maintenance task for performing daily full
> > > database backup into tape drive and it is working fine.
> > >
> > > My problem is after performing the backup it is not ejecting the tape
out of
> > > the drive automatically. Also there is no option available in the
Database
> > > Maintenace Wizard to configure same.
> > >
> > > Can any body help me'
> > >
> > > Thanks
> > > Satyaki
> >
> > Just a suggestion, we leave the tapes in the drive as it shows that the
> > tape did not run out of space. When a tape is full, it ejects so you
> > can put another in - and the person changing the tapes immediately knows
> > something is wrong.
> >
> >
Efficient SQL Backup?
Hi all,
I am having issues of efficiency of backing up data from one SQL data
base to another.
The two servers in questions are on different networks , behind
different firewalls. We have MS SQL 2000.
On the source data i run a job with the following steps:
1> take trans backup every 4 hrs
2> ftp to the remote server
3> if ftp fails , disable the whole job
On the target server I run a job which does the following
1> restore the trans backup with NORECOVERY.
If the job fails at target. I will have to go through the whole process
of doing a complete backup of the source , restoring it at the other
ens and then starting trans-backup again.
Also, if we do a failover to the target server, then when we roll back
to the source server again we have to da a back-up of the target and
restore it on the source server.
Is ther a more efficent way of doing this'Actually, no. This is pretty much what Log Shipping does. If you failover
to the remote and then want to failback to the primary, then you have to get
all of the data from the remote to the primary which means a backup/restore
cycle.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<bajaj.vishal@.gmail.com> wrote in message
news:1145456580.413687.286110@.t31g2000cwb.googlegroups.com...
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>
I am having issues of efficiency of backing up data from one SQL data
base to another.
The two servers in questions are on different networks , behind
different firewalls. We have MS SQL 2000.
On the source data i run a job with the following steps:
1> take trans backup every 4 hrs
2> ftp to the remote server
3> if ftp fails , disable the whole job
On the target server I run a job which does the following
1> restore the trans backup with NORECOVERY.
If the job fails at target. I will have to go through the whole process
of doing a complete backup of the source , restoring it at the other
ens and then starting trans-backup again.
Also, if we do a failover to the target server, then when we roll back
to the source server again we have to da a back-up of the target and
restore it on the source server.
Is ther a more efficent way of doing this'Actually, no. This is pretty much what Log Shipping does. If you failover
to the remote and then want to failback to the primary, then you have to get
all of the data from the remote to the primary which means a backup/restore
cycle.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<bajaj.vishal@.gmail.com> wrote in message
news:1145456580.413687.286110@.t31g2000cwb.googlegroups.com...
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>
Efficient SQL Backup?
Hi all,
I am having issues of efficiency of backing up data from one SQL data
base to another.
The two servers in questions are on different networks , behind
different firewalls. We have MS SQL 2000.
On the source data i run a job with the following steps:
1> take trans backup every 4 hrs
2> ftp to the remote server
3> if ftp fails , disable the whole job
On the target server I run a job which does the following
1> restore the trans backup with NORECOVERY.
If the job fails at target. I will have to go through the whole process
of doing a complete backup of the source , restoring it at the other
ens and then starting trans-backup again.
Also, if we do a failover to the target server, then when we roll back
to the source server again we have to da a back-up of the target and
restore it on the source server.
Is ther a more efficent way of doing this'Sounds like a typical log shipping scenario. If the job fails at source you
do may have the option of applying the logs manually to bring the standby
server up-to-date without restoring the complete backup.
The link below show the process using Microsoft's log shipping solution but
a manual method will achive the same result.
http://www.microsoft.com/technet/pr...fr=
true
"Vishal" wrote:
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>|||I suggest you try in a different forum for server or admin things.
David
"Vishal" <bajaj.vishal@.gmail.com> wrote in message
news:1145456687.737152.87130@.g10g2000cwb.googlegroups.com...
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>|||Thanks a lot. let me try somthing else here .
I am having issues of efficiency of backing up data from one SQL data
base to another.
The two servers in questions are on different networks , behind
different firewalls. We have MS SQL 2000.
On the source data i run a job with the following steps:
1> take trans backup every 4 hrs
2> ftp to the remote server
3> if ftp fails , disable the whole job
On the target server I run a job which does the following
1> restore the trans backup with NORECOVERY.
If the job fails at target. I will have to go through the whole process
of doing a complete backup of the source , restoring it at the other
ens and then starting trans-backup again.
Also, if we do a failover to the target server, then when we roll back
to the source server again we have to da a back-up of the target and
restore it on the source server.
Is ther a more efficent way of doing this'Sounds like a typical log shipping scenario. If the job fails at source you
do may have the option of applying the logs manually to bring the standby
server up-to-date without restoring the complete backup.
The link below show the process using Microsoft's log shipping solution but
a manual method will achive the same result.
http://www.microsoft.com/technet/pr...fr=
true
"Vishal" wrote:
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>|||I suggest you try in a different forum for server or admin things.
David
"Vishal" <bajaj.vishal@.gmail.com> wrote in message
news:1145456687.737152.87130@.g10g2000cwb.googlegroups.com...
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>|||Thanks a lot. let me try somthing else here .
Efficient SQL Backup?
Hi all,
I am having issues of efficiency of backing up data from one SQL data
base to another.
The two servers in questions are on different networks , behind
different firewalls. We have MS SQL 2000.
On the source data i run a job with the following steps:
1> take trans backup every 4 hrs
2> ftp to the remote server
3> if ftp fails , disable the whole job
On the target server I run a job which does the following
1> restore the trans backup with NORECOVERY.
If the job fails at target. I will have to go through the whole process
of doing a complete backup of the source , restoring it at the other
ens and then starting trans-backup again.
Also, if we do a failover to the target server, then when we roll back
to the source server again we have to da a back-up of the target and
restore it on the source server.
Is ther a more efficent way of doing this'Actually, no. This is pretty much what Log Shipping does. If you failover
to the remote and then want to failback to the primary, then you have to get
all of the data from the remote to the primary which means a backup/restore
cycle.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<bajaj.vishal@.gmail.com> wrote in message
news:1145456580.413687.286110@.t31g2000cwb.googlegroups.com...
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>
I am having issues of efficiency of backing up data from one SQL data
base to another.
The two servers in questions are on different networks , behind
different firewalls. We have MS SQL 2000.
On the source data i run a job with the following steps:
1> take trans backup every 4 hrs
2> ftp to the remote server
3> if ftp fails , disable the whole job
On the target server I run a job which does the following
1> restore the trans backup with NORECOVERY.
If the job fails at target. I will have to go through the whole process
of doing a complete backup of the source , restoring it at the other
ens and then starting trans-backup again.
Also, if we do a failover to the target server, then when we roll back
to the source server again we have to da a back-up of the target and
restore it on the source server.
Is ther a more efficent way of doing this'Actually, no. This is pretty much what Log Shipping does. If you failover
to the remote and then want to failback to the primary, then you have to get
all of the data from the remote to the primary which means a backup/restore
cycle.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<bajaj.vishal@.gmail.com> wrote in message
news:1145456580.413687.286110@.t31g2000cwb.googlegroups.com...
> Hi all,
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this'
>
Efficient SQL Backup?
Hi all,
I am having issues of efficiency of backing up data from one SQL data
base to another.
The two servers in questions are on different networks , behind
different firewalls. We have MS SQL 2000.
On the source data i run a job with the following steps:
1> take trans backup every 4 hrs
2> ftp to the remote server
3> if ftp fails , disable the whole job
On the target server I run a job which does the following
1> restore the trans backup with NORECOVERY.
If the job fails at target. I will have to go through the whole process
of doing a complete backup of the source , restoring it at the other
ens and then starting trans-backup again.
Also, if we do a failover to the target server, then when we roll back
to the source server again we have to da a back-up of the target and
restore it on the source server.
Is ther a more efficent way of doing this??Vishal (bajaj.vishal@.gmail.com) writes:
> I am having issues of efficiency of backing up data from one SQL data
> base to another.
> The two servers in questions are on different networks , behind
> different firewalls. We have MS SQL 2000.
> On the source data i run a job with the following steps:
> 1> take trans backup every 4 hrs
> 2> ftp to the remote server
> 3> if ftp fails , disable the whole job
> On the target server I run a job which does the following
> 1> restore the trans backup with NORECOVERY.
> If the job fails at target. I will have to go through the whole process
> of doing a complete backup of the source , restoring it at the other
> ens and then starting trans-backup again.
> Also, if we do a failover to the target server, then when we roll back
> to the source server again we have to da a back-up of the target and
> restore it on the source server.
> Is ther a more efficent way of doing this??
I'm not sure exactly the purpose of this home-made log shipping is,
but could replication be a better alternative?
(Although, I have no idea whether replication can cross your network
and firewalls.)
--
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|||As per my understanding you are concerned with
3> if ftp fails , disable the whole job
* If you want to save time then you can go ahead and use SQL Litespeed
tool.
You can go through this article for more information.
http://www.sql-server-performance.c...d_spotlight.asp
Thanks
Ajay Rengunthwar (Ajay)|||thnks a lot, but will i be able to do a failover easily ? and can i do
transactional backups and keep restoring it at the other end. I cannot
do a complete backup due to bandwidth constraints.
Wednesday, February 15, 2012
Editing scheduled backups and time stamping backup files
Sorry for the previous post. Here are the problems:
1. Using enterprise manager, I chose to backup a
database. I picked my backup device and checked the
schedule option, setup the time and frequency of the
backup. It worked properly. How does one go in and edit
or modify the schedule after it is created? I went to
the backup device but, it doesn't show my schedule name
or settings, in fact, it shows the schedule option
unchecked. Any ideas or is it a matter of deleting the
device and recreating it?
2. I want to have each full backup have the basic file
name but have a time stamp added into the name. It would
look something like: databasename_db_200408141830. 2004
is the year, 08 the month, 14 the day, 1830 the hour. I
have seen it done but do not know how to duplicate it.
By doing this, I can go back to previous backups if a
problem occurs. Once again, any ideas?inline...
HTH
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
"smantz" <smantz@.smhscs.org> wrote in message
news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> Sorry for the previous post. Here are the problems:
> 1. Using enterprise manager, I chose to backup a
> database. I picked my backup device and checked the
> schedule option, setup the time and frequency of the
> backup. It worked properly. How does one go in and edit
> or modify the schedule after it is created? I went to
> the backup device but, it doesn't show my schedule name
> or settings, in fact, it shows the schedule option
> unchecked. Any ideas or is it a matter of deleting the
> device and recreating it?
the device actually will not show anything until it has been initialized. if
you want to edit the backup job itself you will find it under the
management, SQL agent, jobs. you 'll find it there.
> 2. I want to have each full backup have the basic file
> name but have a time stamp added into the name. It would
> look something like: databasename_db_200408141830. 2004
> is the year, 08 the month, 14 the day, 1830 the hour. I
> have seen it done but do not know how to duplicate it.
> By doing this, I can go back to previous backups if a
> problem occurs. Once again, any ideas?
>
the best way to do this is to create the backup job in database management
section. here you can create a scheduled backup and it will automatically
append the date/time of the backup.|||sorry I should be a bit more specific. you should look for the database
maintenance plan wizard. it can reindex, update statistics, backup database
and tlogs, and send notifications of job completion (I like this last one,
sends me an e-mail over lunch that my tlog backup has completed successfully
or not. it does take a bit more setup for the mail portion).
I'm a huge fan of the Maint.wizards but it shouldn't be the only way you
create these jobs. give em a shot...
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
/* Check out the books on-line (BOL) for more one the above */
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:#3XtUUB$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> inline...
> HTH
> Neil MacMurchy
> Senior DBA
> Regional Municipality of Niagara
> "smantz" <smantz@.smhscs.org> wrote in message
> news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> > Sorry for the previous post. Here are the problems:
> > 1. Using enterprise manager, I chose to backup a
> > database. I picked my backup device and checked the
> > schedule option, setup the time and frequency of the
> > backup. It worked properly. How does one go in and edit
> > or modify the schedule after it is created? I went to
> > the backup device but, it doesn't show my schedule name
> > or settings, in fact, it shows the schedule option
> > unchecked. Any ideas or is it a matter of deleting the
> > device and recreating it?
> the device actually will not show anything until it has been initialized.
if
> you want to edit the backup job itself you will find it under the
> management, SQL agent, jobs. you 'll find it there.
> >
> > 2. I want to have each full backup have the basic file
> > name but have a time stamp added into the name. It would
> > look something like: databasename_db_200408141830. 2004
> > is the year, 08 the month, 14 the day, 1830 the hour. I
> > have seen it done but do not know how to duplicate it.
> > By doing this, I can go back to previous backups if a
> > problem occurs. Once again, any ideas?
> >
> the best way to do this is to create the backup job in database management
> section. here you can create a scheduled backup and it will automatically
> append the date/time of the backup.
>
1. Using enterprise manager, I chose to backup a
database. I picked my backup device and checked the
schedule option, setup the time and frequency of the
backup. It worked properly. How does one go in and edit
or modify the schedule after it is created? I went to
the backup device but, it doesn't show my schedule name
or settings, in fact, it shows the schedule option
unchecked. Any ideas or is it a matter of deleting the
device and recreating it?
2. I want to have each full backup have the basic file
name but have a time stamp added into the name. It would
look something like: databasename_db_200408141830. 2004
is the year, 08 the month, 14 the day, 1830 the hour. I
have seen it done but do not know how to duplicate it.
By doing this, I can go back to previous backups if a
problem occurs. Once again, any ideas?inline...
HTH
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
"smantz" <smantz@.smhscs.org> wrote in message
news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> Sorry for the previous post. Here are the problems:
> 1. Using enterprise manager, I chose to backup a
> database. I picked my backup device and checked the
> schedule option, setup the time and frequency of the
> backup. It worked properly. How does one go in and edit
> or modify the schedule after it is created? I went to
> the backup device but, it doesn't show my schedule name
> or settings, in fact, it shows the schedule option
> unchecked. Any ideas or is it a matter of deleting the
> device and recreating it?
the device actually will not show anything until it has been initialized. if
you want to edit the backup job itself you will find it under the
management, SQL agent, jobs. you 'll find it there.
> 2. I want to have each full backup have the basic file
> name but have a time stamp added into the name. It would
> look something like: databasename_db_200408141830. 2004
> is the year, 08 the month, 14 the day, 1830 the hour. I
> have seen it done but do not know how to duplicate it.
> By doing this, I can go back to previous backups if a
> problem occurs. Once again, any ideas?
>
the best way to do this is to create the backup job in database management
section. here you can create a scheduled backup and it will automatically
append the date/time of the backup.|||sorry I should be a bit more specific. you should look for the database
maintenance plan wizard. it can reindex, update statistics, backup database
and tlogs, and send notifications of job completion (I like this last one,
sends me an e-mail over lunch that my tlog backup has completed successfully
or not. it does take a bit more setup for the mail portion).
I'm a huge fan of the Maint.wizards but it shouldn't be the only way you
create these jobs. give em a shot...
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
/* Check out the books on-line (BOL) for more one the above */
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:#3XtUUB$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> inline...
> HTH
> Neil MacMurchy
> Senior DBA
> Regional Municipality of Niagara
> "smantz" <smantz@.smhscs.org> wrote in message
> news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> > Sorry for the previous post. Here are the problems:
> > 1. Using enterprise manager, I chose to backup a
> > database. I picked my backup device and checked the
> > schedule option, setup the time and frequency of the
> > backup. It worked properly. How does one go in and edit
> > or modify the schedule after it is created? I went to
> > the backup device but, it doesn't show my schedule name
> > or settings, in fact, it shows the schedule option
> > unchecked. Any ideas or is it a matter of deleting the
> > device and recreating it?
> the device actually will not show anything until it has been initialized.
if
> you want to edit the backup job itself you will find it under the
> management, SQL agent, jobs. you 'll find it there.
> >
> > 2. I want to have each full backup have the basic file
> > name but have a time stamp added into the name. It would
> > look something like: databasename_db_200408141830. 2004
> > is the year, 08 the month, 14 the day, 1830 the hour. I
> > have seen it done but do not know how to duplicate it.
> > By doing this, I can go back to previous backups if a
> > problem occurs. Once again, any ideas?
> >
> the best way to do this is to create the backup job in database management
> section. here you can create a scheduled backup and it will automatically
> append the date/time of the backup.
>
Editing scheduled backups and time stamping backup files
Sorry for the previous post. Here are the problems:
1. Using enterprise manager, I chose to backup a
database. I picked my backup device and checked the
schedule option, setup the time and frequency of the
backup. It worked properly. How does one go in and edit
or modify the schedule after it is created? I went to
the backup device but, it doesn't show my schedule name
or settings, in fact, it shows the schedule option
unchecked. Any ideas or is it a matter of deleting the
device and recreating it?
2. I want to have each full backup have the basic file
name but have a time stamp added into the name. It would
look something like: databasename_db_200408141830. 2004
is the year, 08 the month, 14 the day, 1830 the hour. I
have seen it done but do not know how to duplicate it.
By doing this, I can go back to previous backups if a
problem occurs. Once again, any ideas?inline...
HTH
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
"smantz" <smantz@.smhscs.org> wrote in message
news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> Sorry for the previous post. Here are the problems:
> 1. Using enterprise manager, I chose to backup a
> database. I picked my backup device and checked the
> schedule option, setup the time and frequency of the
> backup. It worked properly. How does one go in and edit
> or modify the schedule after it is created? I went to
> the backup device but, it doesn't show my schedule name
> or settings, in fact, it shows the schedule option
> unchecked. Any ideas or is it a matter of deleting the
> device and recreating it?
the device actually will not show anything until it has been initialized. if
you want to edit the backup job itself you will find it under the
management, SQL agent, jobs. you 'll find it there.
> 2. I want to have each full backup have the basic file
> name but have a time stamp added into the name. It would
> look something like: databasename_db_200408141830. 2004
> is the year, 08 the month, 14 the day, 1830 the hour. I
> have seen it done but do not know how to duplicate it.
> By doing this, I can go back to previous backups if a
> problem occurs. Once again, any ideas?
>
the best way to do this is to create the backup job in database management
section. here you can create a scheduled backup and it will automatically
append the date/time of the backup.|||sorry I should be a bit more specific. you should look for the database
maintenance plan wizard. it can reindex, update statistics, backup database
and tlogs, and send notifications of job completion (I like this last one,
sends me an e-mail over lunch that my tlog backup has completed successfully
or not. it does take a bit more setup for the mail portion).
I'm a huge fan of the Maint.wizards but it shouldn't be the only way you
create these jobs. give em a shot...
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
/* Check out the books on-line (BOL) for more one the above */
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:#3XtUUB$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> inline...
> HTH
> Neil MacMurchy
> Senior DBA
> Regional Municipality of Niagara
> "smantz" <smantz@.smhscs.org> wrote in message
> news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> the device actually will not show anything until it has been initialized.
if
> you want to edit the backup job itself you will find it under the
> management, SQL agent, jobs. you 'll find it there.
>
> the best way to do this is to create the backup job in database management
> section. here you can create a scheduled backup and it will automatically
> append the date/time of the backup.
>
1. Using enterprise manager, I chose to backup a
database. I picked my backup device and checked the
schedule option, setup the time and frequency of the
backup. It worked properly. How does one go in and edit
or modify the schedule after it is created? I went to
the backup device but, it doesn't show my schedule name
or settings, in fact, it shows the schedule option
unchecked. Any ideas or is it a matter of deleting the
device and recreating it?
2. I want to have each full backup have the basic file
name but have a time stamp added into the name. It would
look something like: databasename_db_200408141830. 2004
is the year, 08 the month, 14 the day, 1830 the hour. I
have seen it done but do not know how to duplicate it.
By doing this, I can go back to previous backups if a
problem occurs. Once again, any ideas?inline...
HTH
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
"smantz" <smantz@.smhscs.org> wrote in message
news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> Sorry for the previous post. Here are the problems:
> 1. Using enterprise manager, I chose to backup a
> database. I picked my backup device and checked the
> schedule option, setup the time and frequency of the
> backup. It worked properly. How does one go in and edit
> or modify the schedule after it is created? I went to
> the backup device but, it doesn't show my schedule name
> or settings, in fact, it shows the schedule option
> unchecked. Any ideas or is it a matter of deleting the
> device and recreating it?
the device actually will not show anything until it has been initialized. if
you want to edit the backup job itself you will find it under the
management, SQL agent, jobs. you 'll find it there.
> 2. I want to have each full backup have the basic file
> name but have a time stamp added into the name. It would
> look something like: databasename_db_200408141830. 2004
> is the year, 08 the month, 14 the day, 1830 the hour. I
> have seen it done but do not know how to duplicate it.
> By doing this, I can go back to previous backups if a
> problem occurs. Once again, any ideas?
>
the best way to do this is to create the backup job in database management
section. here you can create a scheduled backup and it will automatically
append the date/time of the backup.|||sorry I should be a bit more specific. you should look for the database
maintenance plan wizard. it can reindex, update statistics, backup database
and tlogs, and send notifications of job completion (I like this last one,
sends me an e-mail over lunch that my tlog backup has completed successfully
or not. it does take a bit more setup for the mail portion).
I'm a huge fan of the Maint.wizards but it shouldn't be the only way you
create these jobs. give em a shot...
Neil MacMurchy
Senior DBA
Regional Municipality of Niagara
/* Check out the books on-line (BOL) for more one the above */
"Neil MacMurchy" <neilmcse@.hotmail.com> wrote in message
news:#3XtUUB$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> inline...
> HTH
> Neil MacMurchy
> Senior DBA
> Regional Municipality of Niagara
> "smantz" <smantz@.smhscs.org> wrote in message
> news:1a3301c3fc09$ee42b440$a401280a@.phx.gbl...
> the device actually will not show anything until it has been initialized.
if
> you want to edit the backup job itself you will find it under the
> management, SQL agent, jobs. you 'll find it there.
>
> the best way to do this is to create the backup job in database management
> section. here you can create a scheduled backup and it will automatically
> append the date/time of the backup.
>
Subscribe to:
Posts (Atom)