Advertisement

05.20.2008 at 07:07AM PDT, ID: 23417178
[x]
Attachment Details

What is needed to make this .bat file backup sql server 2005 database?

Asked by teamsj in MS SQL Server, SQL Query Syntax, SQL Server 2005

Tags: Microsoft, SQL SERVER 2005

I have the following code in a file called mssqlscript.bat and what i want to do is simply double click it and have it run the backup.  It currently doesn't do anything when I double click it.  These same commands work fine when I use them in the sqlcommand line.  I assume that I will have to add username and password, etc., but I don't know the syntax.Start Free Trial
1:
2:
BACKUP DATABASE [sde] TO  DISK = N'E:\SDE db backups\vmcsde' WITH NOFORMAT, INIT,  NAME = N'sde-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
[+][-]05.20.2008 at 07:11AM PDT, ID: 21606292

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 07:12AM PDT, ID: 21606305

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Query Syntax, SQL Server 2005
Tags: Microsoft, SQL SERVER 2005
Sign Up Now!
Solution Provided By: matrix_aash
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628