create a maintenance plan for Full Backup that includes the copy backup to the network drive

Question

Post reply

create a maintenance plan for Full Backup that includes the copy backup to the network drive

sureshdeenu

Right there with Babe

Points: 796
More actions
March 5, 2010 at 9:24 am

#386449

Guys I need help using Maintainence plan designer, i want to create a maintainence plan that creates Full Backup everyday. Once it takes the full backup with in the maintenance Plan i want to include the step to create a copy of the full backup in my network drive. I want to do this for all my user databases with in the single Maintenance plan. I am a new to sql server. pls help

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

To create a Backup Plan

http://www.databasejournal.com/features/mssql/article.php/3665841/Microsoft-SQL-2005-Maintenance-Wizard-Part-3.htm

To manage the files on disk:

http://www.mssqltips.com/tip.asp?tip=1094

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sureshdeenu Right there with Babe Points: 796 More actions · Answer 2

Here I am actully looking to copy my .bak file to a network drive once the backup was done, I want use xp_cmdshell to copy the files

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

I suggest creating the maint plan first then. Once the maint plan is done, then I would either create a new SSIS package, or alter your maint plan from SSIS. From within BIDS, you can add a task to perform file system operations using SQL queries if need be. From this task you can specify to use xp_cmdshell.

Of course, the use of xp_cmdshell is assuming that policy permits the use of it in your environment.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeffrey Williams SSC Guru Points: 90250 More actions · Answer 4

sureshdeenu (3/8/2010)
Here I am actully looking to copy my .bak file to a network drive once the backup was done, I want use xp_cmdshell to copy the files

You really don't want to do it this way - what you want to do is create an agent job that executes your copy command. Then, in your maintenance plan you add a task as the last task of the plan that starts that agent job.

This way, you don't have to enable xp_cmdshell and you have the ability to re-run the agent job if needed. I would recommend using Robocopy to perform the copy, which is usually a better tool for copying large files.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

sureshdeenu Right there with Babe Points: 796 More actions · Answer 5

thank you this is what I am looking for, appreciate for all responses