Re: SQL Backup and Restore
From: lwood (lwood_at_discussions.microsoft.com)
Date: 01/06/05
- Next message: John Mullin: "SQL Server confused about primary keys. So am I."
- Previous message: David Gugick: "Re: SQL Server was blocked by a query"
- Next in thread: Keith Kratochvil: "Re: SQL Backup and Restore"
- Reply: Keith Kratochvil: "Re: SQL Backup and Restore"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 Jan 2005 22:13:02 -0800
Keith,
the remote restore works great from query analyzer, but when i try to run it
from a job it appears to receive a login failure. I have tried all ID's in
the list but it will not run. Any ideas on how to setup the access in the job
to run appropriately. The job failed initially thru query analyzer until I
modified the authentication on the linked server?
Thanks Again for all of your help!!
Lisa
"Keith Kratochvil" wrote:
> Yes, it is easy if the file name does not change.
>
> You could create a job on your remote server that issues the restore
> command. When the backup job on the primary server is complete you can add
> one more step to your backup job on the primary server that looks something
> like this:
>
> exec TheRemoteLinkedServerName.msdb.dbo.sp_start_job @job_name = 'Name of
> the restore job goes here', @server_name = 'the remote server name goes
> here'
>
> --
> Keith
>
>
> "lwood" <lwood@discussions.microsoft.com> wrote in message
> news:82842BE8-EAFD-4EEB-A5B6-828F6885416C@microsoft.com...
> > I would like to backup my SQL db every night copy to a remote server and
> > restore it nightly. I have not been able to locate information on how to
> > automate the restore. I currently have an automated backup copied to the
> > second server but am manually restoring the file. Would it be easiest if
> the
> > filename to backup to remained the same each day? Currently the backups
> > default to db name date and time. Any help is greatly appreciated!
>
>
- Next message: John Mullin: "SQL Server confused about primary keys. So am I."
- Previous message: David Gugick: "Re: SQL Server was blocked by a query"
- Next in thread: Keith Kratochvil: "Re: SQL Backup and Restore"
- Reply: Keith Kratochvil: "Re: SQL Backup and Restore"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
