VBScript for SQL Database Backup...

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

VBScript for SQL Database Backup...

Logged in as: Guest

arrSession:exec spGetSession 2,2,60017

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> VBScript for SQL Database Backup...
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

VBScript for SQL Database Backup... - 5/8/2008 9:52:21 PM

marconi

Posts: 8
Score: 0
Joined: 5/7/2008
Status: offline

Original message moved by TNO
Reason :
Hi,

I have 1 maintenance Database Server and 3 Job Servers. I want to take a Backup of SQL Database and restore it on all the
3 Job Servers.

I have the following VBScript. But the script is failing with the message "backup failed with message..."

---------------------------------------------------------------------------------------------------------------------------------------------
Option Explicit
Dim server
Dim backup
Set server = CreateObject("Microsoft.SQLServer.Management.SMO.Server")
Set backup = CreateObject("Microsoft.SQLServer.Management.SMO.Backup")
backup.Action = 0
backup.Database = "test_old"
backup.SqlBackup(server)
------------------------------------------------------------------------------------------------------------------------------------------------

Request you to please let me know the corrections in my script or a new script to achieve my purpose.

Thanks a lot in advance.

Best Regards,
KiranKumar K.