Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Stored Procedure to Backup all Databases

By Wesley Brown,

This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user : Login name for the FTP server @upass : Password for the FTP server @path : Local path files will be written to first. Thats it there is no return value. There are errors raised and logged in the script. Is there a cleaner better way to do this? I bet there is. I haven't seen one though. Enjoy

Total article views: 4425 | Views in the last 30 days: 10
 
Related Articles
FORUM

there is any Way in SQL-Server?

there is any Way in SQL-Server?

FORUM

is there any too to migrate SQL Server jobs?

is there any too to migrate SQL Server jobs?

ARTICLE

Why Are There So Many Editions?

SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so ...

FORUM

SQL Server Agent will not start and there are no error logs.

SQL Server Agent will not start after changeing service account and there are no error logs.

FORUM

Is there any way to flush out a stuck process in sql server

Is there any way out to flush out a stuck process in sql server....

Tags
 
Contribute