Hi.. Im using following query for getting DB Backup But i got error Pls help me.. thhis is correct for getting DB backup else pls post some code DB backup & restore Thanks in advance.. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- backup a database ALTER PROCEDURE [dbo].[sp_BackupDatabase] @databasename varchar(32), @path varchar(256), @filename varchar(64)AS set nocount on declare @sql varchar(4000) select @sql ='BACKUP DATABASE ' + ltrim(rtrim( @databasename )) select @sql = @sql +'TO DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim(@filename)) + ''' ' select @sql = @sql +'WITH INIT' --print @sql execute ( @sql ) select 'Database successfully backed up!' [Result]

HI.. This is my backup query.. its not workin Pls send me wat's the error in this query and how to get backup database.. alter PROCEDURE [dbo].[sp_BackupDatabase] @databasename varchar(32), @path varchar(256), @filename varchar(64)AS set nocount on declare @sql varchar(4000) select @sql ='BACKUP DATABASE ' + ltrim(rtrim( @databasename )) select @sql = @sql +'TO DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim(@filename)) + ''' ' select @sql = @sql +'WITH INIT' print @sql execute ( @sql ) select 'Database successfully backed up!' [Result]

Also im trying this.. That's also using smo retrive server name and DB with connect management studio.. But I need all project DB backup without installed management studio, only installed express edition..Bcos client machine have express edition not in management studio.. Any idea.

Hi.. I'm using sql server 2005 Standard Edition and vs 2005 im trying to get database backup & restore with c# coding its succesfull run in my machine.(Using smo namespace)..my machine are installed management studio so smo retrive server name and DB.. But when i was create exe this backup application and run client machine its not run.. Bcoz client machine only installed express edition not in management studio.. Client machine have some software with Database(path c:\Program Files\Test\) in this case how can i get backup & Restore in client machine...? Pls help me..?

Hi.. Im new for windows applications.. i hav one doubt.. Im using vs 2005 and sql server 2005 Sqlexpress.. i need to get backup & Restore Databases.. im trying and got it through c# code (using smo). After successfully im create exe in my application and run client machine.. client machine have some project with DB..(DB mdf and log file Path is c:\test1\test2\test3) i want to get client machine DB backup Restore..But client machine installed only express edition not a management studio.. in this case how to get DB backup and restore in client machine.. Pls help me.. wat can i do..?