what is the best method to install SQL server Express 2005 programmatically
Database
1
Posts
1
Posters
0
Views
1
Watching
-
hi all, i want to install SQL server Express 2005 programmatically. so i use following statement
str = Application.StartupPath & "\SQLEXPR32\setup.exe /qb ADDLOCAL=ALL INSTANCENAME=" & InstanceName & " SECURITYMODE=SQL SAPWD=password DISABLENETWORKPROTOCOLS=0 " Shell(str, AppWinStyle.Hide, True)
above code works well. but when i try to Create backup pro grammatically, then it create backup only in Backup folder of SQL server. if i specify other path(other then Backup) then Backup process failed. Please suggest