Red gate back up tool command - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Red gate back up tool command

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-01-13 : 05:43:52

Dear All,

If somebody having usage experience of Redgate back up toll pls help me.
I need to schedule the backup with .batch file..
How to use the back up command for this in batch file.

Thanks,
Gangadhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-13 : 12:22:03

We use both Quest's Litespeed and Red Gate's SQL Backup program. I've created custom code to do the backups of both. For Red Gate, just pass SB to the backup type parameter. Here's my code: http://weblogs.sqlteam.com/tarad/archive/2009/12/29/Backup-SQL-Server-2005-and-2008-DatabasesAgain.aspx

If you want it in a batch file, then just run sqlcmd.exe and call the code.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources