Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

backup and restore a database that changes everyday

Created: 27 Aug 2012 • Updated: 10 Sep 2012 | 6 comments
This issue has been solved. See solution.

I have 2 SQL servers

I want backup 4 databases from 1st server and restore to second with backup exec,

these databases change everyday,

who can help me?

Do you have any solution?

Comments 6 CommentsJump to latest comment

CraigV's picture

Hi there,

 

Backing them up isn't a hassle. Create a backup job/policy and select the databases before putting them on a schedule.

Automatically restoring them is another story, and this can't be done with BE at all. Certainly not BE 2010 and earlier versions. You will have to manually run the restore yourself.

You can try going to the Ideas section below & adding it in, but I don't know what the chances of it being implemented will be.

https://www-secure.symantec.com/connect/backup-and-recovery/ideas

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

Ben L.'s picture

You won't be able to schedule the restores as CraigV said.

But if you are using SQL 2005 SP1 or higher, you can use Database Mirroring to do this.

http://msdn.microsoft.com/en-US/library/cc917680

If this response answers your concern, please mark it as a "solution"

Ken Putnam's picture

Any reason you can't just schedule a SQL-to-SQL copy?

 

 

 

If this response answers your concern, please mark it as a "solution"

Houshyar's picture

I Don't know how can do that,

I have a physical server with about 70 databases, I want copy only 4 of them to a virtual machine every day but i don't know how can i do this.

Do you have any suggestion?

CraigV's picture

...won't be done through BE at all. You cannot schedule a restore, much less a restore of selected data. You would need to look at something else.

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

SOLUTION
Ken Putnam's picture

it has been a looooong time since I did much with SQL Server, but using SQL Admin (or whatever it is called nowdays) you should be able to schedule a database to database copy

If this response answers your concern, please mark it as a "solution"