Video Screencast Help

backup sql server 2000 to tape

Created: 27 Sep 2011 • Updated: 22 Feb 2013 | 2 comments
This issue has been solved. See solution.

1 ) what are the best practices for  sql server 2000 backup to tape and how to do

2 ) i would like to run exchange 2010 backup to disk from tape , how to do that

 

Backup exec 2010 r3

Comments 2 CommentsJump to latest comment

CraigV's picture

Hi there,

 

In both cases, the best way to backup SQL and Exchange will be via the agent as it allows online backups and restores of information.

If you don't have the agents, you'll have to create a script to stop both SQL and Exchange, and then kick off a backup job to backup the flat-files. When you restore, you'd need to take down both applications in order to do so and also look at a third party application like Kernel for Exchange to extract information out of the flat file.

To back them up, you need to do the following:

1. Create a selection list and select both SQL and Exchange. You can select them in the same job, but try not to mix data with them, or use Advanced Option File Option.

2. Create either a stand-alone job or a policy (if you want to use GFS - daily, monthly, weekly). During the creation of the job/s, you'll set the days and times the job/s will run at, and then at the end, select the selection list you created in 1.

3. It will also ask you whether or not you want to use an existing media set, or create a new one...this is where you will set your retention periods.

 

Thanks!

 

EDIT: THis link has all the Symantec BE 2010 Best Practices...make sure you read through the relevant articles to familiarise yourself with what is requried:

http://www.symantec.com/business/support/index?page=content&id=TECH126401

 

The link below will walk you through how to create a job:

http://www.symantec.com/business/support/index?page=content&id=HOWTO31077

 

Also get hold of the BE 2010 Admin Guide as this is very helpful with background information you might need.

Alternative ways to access Backup Exec Technical Support:

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

SOLUTION
supportsib2's picture

 

Below is the last part from the  article " Best practices for Backup Exec 2010 Agent for Microsoft SQL Server"

 

 

Do not apply the credentials that you use to make SQL backup and restore selections to an actual SQL instance. The credentials that you use to make SQL backup and restore selections must be applied to the Windows computer where SQL is installed.

Note:

If you use SQL-generated credentials, you must apply those credentials at the SQL instance level.

 

 

Can some one explain  it?