Backup « SQLserver « C Q&A

1. How to take backup in MS SQL through programming without using MSsql services window    forums.devshed.com

I want to make a utility in my VB project to take backup, But my back end is MSsQL 7 and My user is layman so I want to give facility to automatic back up ,only on a single click of button IS this possible without opening a MS SQL manager ? Second i have tried to export my database to ...

2. error about sql server 2005 , why can't backup to c:\    dbforums.com

this is code: Dim strSQL As String Dim strCon As String strCon = "Data Source=NITHI;Initial Catalog=master;Integrated Security=True" Dim cmdBackup As SqlClient.SqlCommand = New SqlClient.SqlCommand Cursor = Cursors.WaitCursor Try strSQL = "BACKUP DATABASE Northwind " strSQL &= "TO DISK = 'G:\mybackup.bak' " strSQL &= "WITH FORMAT, " strSQL &= "NAME = 'myBackup'" cmdBackup.Connection = conn cmdBackup.CommandText = strSQL cmdBackup.ExecuteNonQuery() MsgBox("finish") Catch ex ...

3. Correct the Syntex for : Backup Locally and then C    sqlteam.com

4. HOW to change SQL server from C:\Programfiles\microsoftSQLserver into "D" drive?    sqlservercentral.com

Hello, guys how are you doing? I have DHCP server and my HDD has two partitions which is PRAIMARY partition ( C & D). and Drive "C" partition is very small and its capacitiy = 39GB & free space = 18GB while Drive "D" partition is capacity = 164GB and free space = 155GB. this is a big mistake made by ...