Complete Backup and Restore

[malikjaved]

Hi All,

i am very new to vb.net, and my boss have given me a project to do it, v have quite big sql server 2005 database with full text catalogs.

so what i need is to do, is to take the back on a specific location and restore the database in new location with new name and the index , log and catalogs files should also be on specific defined location,

So can anyone help me regurding this by send me sample code which any help me.


Thanks and looking forward.
-MALIK

 

[jmcilhinney]

Go to the MSDN Library and read about SQL Server Management Objects (SMO). It is a managed library that lets you access SQL Server functionality in code. With that you should be able to do what you want fairly easily.

 

[jmcilhinney]

Actually, you may well be able to do it all just using T-SQL. I'm no database guru but I'd go to MSDN and read about the BACKUP DATABASE and RESTORE DATABASE statements in the T-SQL reference first.