We moved a server from one box to another. I restored
MSDB to the new server and some of the jobs didn't run as
scheduled. What should I have done to avoid this? It
appears the timing was thrown off. Any experience with
this shared would be appreciated.
Thanks.Hi,
1. Stop the SQL Agent service
2. Since you restored the MSDB from a differnt server you need to update
the SYSJOBS table wth current sql server name,
Because the servername in the table will be source server and all the jobs
will fail.
How to update:-
UPDATE MSDB..SYSJOBS
SET Originating Server = @.@.Servername
WHERE Originating Server <> @.@.Servername
3. start sql agent service
Thanks
Hari
MCDBA
"metoonyc" <metoonyc
"Sandi" <sandra_richardson@.harvardpilgrim.org> wrote in message
news:bc8f01c4895a$65be0370$a401280a@.phx.gbl...
> We moved a server from one box to another. I restored
> MSDB to the new server and some of the jobs didn't run as
> scheduled. What should I have done to avoid this? It
> appears the timing was thrown off. Any experience with
> this shared would be appreciated.
> Thanks.
Showing posts with label scheduled. Show all posts
Showing posts with label scheduled. Show all posts
Tuesday, March 20, 2012
Friday, March 9, 2012
Restoring log & backup
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
AntThe log files will bring you closer to the most recent state of the original
DB.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant|||Hello,
To bring the database up to latest you may need to restore the LOG backups
as well.
Perform below:-
1. Restore the lastest full database backup with NORECOVERY
2. Restore the subsequent log backups one by one with NORECOVER until last
log backup
3. Restore the last log backup with RECOVERY to make the database
operational.
Thanks
Hari
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
> Hi,
> Our SQL server has a database with scheduled backups which backup the
> database & the log file of our production site.
> I would like to restore this backup to our test DB with the production
> backup in order for it to resemble the production one. Should I uncheck
> the
> log file backup when restoring or is it ok to restore it as well? Both
> files
> come up in the restore as ticked. What are the implications of this?
> Thanks very much for any ideas on this
> Ant
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
AntThe log files will bring you closer to the most recent state of the original
DB.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant|||Hello,
To bring the database up to latest you may need to restore the LOG backups
as well.
Perform below:-
1. Restore the lastest full database backup with NORECOVERY
2. Restore the subsequent log backups one by one with NORECOVER until last
log backup
3. Restore the last log backup with RECOVERY to make the database
operational.
Thanks
Hari
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
> Hi,
> Our SQL server has a database with scheduled backups which backup the
> database & the log file of our production site.
> I would like to restore this backup to our test DB with the production
> backup in order for it to resemble the production one. Should I uncheck
> the
> log file backup when restoring or is it ok to restore it as well? Both
> files
> come up in the restore as ticked. What are the implications of this?
> Thanks very much for any ideas on this
> Ant
Restoring log & backup
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant
The log files will bring you closer to the most recent state of the original
DB.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant
|||Hello,
To bring the database up to latest you may need to restore the LOG backups
as well.
Perform below:-
1. Restore the lastest full database backup with NORECOVERY
2. Restore the subsequent log backups one by one with NORECOVER until last
log backup
3. Restore the last log backup with RECOVERY to make the database
operational.
Thanks
Hari
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
> Hi,
> Our SQL server has a database with scheduled backups which backup the
> database & the log file of our production site.
> I would like to restore this backup to our test DB with the production
> backup in order for it to resemble the production one. Should I uncheck
> the
> log file backup when restoring or is it ok to restore it as well? Both
> files
> come up in the restore as ticked. What are the implications of this?
> Thanks very much for any ideas on this
> Ant
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant
The log files will bring you closer to the most recent state of the original
DB.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant
|||Hello,
To bring the database up to latest you may need to restore the LOG backups
as well.
Perform below:-
1. Restore the lastest full database backup with NORECOVERY
2. Restore the subsequent log backups one by one with NORECOVER until last
log backup
3. Restore the last log backup with RECOVERY to make the database
operational.
Thanks
Hari
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
> Hi,
> Our SQL server has a database with scheduled backups which backup the
> database & the log file of our production site.
> I would like to restore this backup to our test DB with the production
> backup in order for it to resemble the production one. Should I uncheck
> the
> log file backup when restoring or is it ok to restore it as well? Both
> files
> come up in the restore as ticked. What are the implications of this?
> Thanks very much for any ideas on this
> Ant
Restoring log & backup
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
AntThe log files will bring you closer to the most recent state of the original
DB.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant|||Hello,
To bring the database up to latest you may need to restore the LOG backups
as well.
Perform below:-
1. Restore the lastest full database backup with NORECOVERY
2. Restore the subsequent log backups one by one with NORECOVER until last
log backup
3. Restore the last log backup with RECOVERY to make the database
operational.
Thanks
Hari
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
> Hi,
> Our SQL server has a database with scheduled backups which backup the
> database & the log file of our production site.
> I would like to restore this backup to our test DB with the production
> backup in order for it to resemble the production one. Should I uncheck
> the
> log file backup when restoring or is it ok to restore it as well? Both
> files
> come up in the restore as ticked. What are the implications of this?
> Thanks very much for any ideas on this
> Ant
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
AntThe log files will bring you closer to the most recent state of the original
DB.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant|||Hello,
To bring the database up to latest you may need to restore the LOG backups
as well.
Perform below:-
1. Restore the lastest full database backup with NORECOVERY
2. Restore the subsequent log backups one by one with NORECOVER until last
log backup
3. Restore the last log backup with RECOVERY to make the database
operational.
Thanks
Hari
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
> Hi,
> Our SQL server has a database with scheduled backups which backup the
> database & the log file of our production site.
> I would like to restore this backup to our test DB with the production
> backup in order for it to resemble the production one. Should I uncheck
> the
> log file backup when restoring or is it ok to restore it as well? Both
> files
> come up in the restore as ticked. What are the implications of this?
> Thanks very much for any ideas on this
> Ant
Subscribe to:
Posts (Atom)