MS Sql Database auto restore

Category: sql server distributed

Question

MS Sql auto Restore on Tue, 27 Nov 2012 14:09:57


how to restore auto database SQL Server 2008 R2 daily base in other server ?

Replies

MS Sql auto Restore on Tue, 27 Nov 2012 14:12:29


how to restore auto database SQL Server 2008 R2 daily base in other server ?

And also other server database store location is differant.

  


Elmozamil Elamir on Mon, 24 Dec 2012 05:42:58


Hi,

I think it is better to use SSIS package and schedule it using SQL Server agent.

I hope this is helpful.

Database Experts on Wed, 26 Dec 2012 06:53:15


Make Script and schedule the job.

For E.g.

Database backup file Name:Full_DBA_2612201.bak.(Full_DatabaseName_Date.bak)

File Folder path and read files from backup folder.

Extract database name from backup file.

use [master]
go

RESTORE DATABASE DBA FROM  
DISK = N'C:\dmp\full_DCDB2_MediaSurvey_22-04-2012.BAK'
WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  REPLACE,  STATS = 10
GO

Kumar muppa on Thu, 03 Jan 2013 02:59:28


Hi there,

It is important to know where you are backing up your database.

What makes you to restore. Are you overwriting the existing or creating a new database from backup.

If you use net backup to back up your database every time SAN backup image will change so you need to get that information and create a restore command and use that in your agent step. You can schedule this agent task on a regular basis.

Good luck

kumar