|
-
Jan 6th, 2010, 11:20 AM
#1
Thread Starter
Addicted Member
[RESOLVED] "Down" a SQL Server/Detach & Re-attach a Database to SQL Server
Hi guys. I would like to know if it is possible to "down" (stop) a running SQL Server or detach and then re-attach a database to an instance of SQL Server via code? You see, I would like to back-up (well, actually, it's more of to copy) the database, but, since you are not allowed to copy/delete/move any attached databases, what I would like to do is either to detach the attached database, copy it to a backup folder, then re-attach it, or to simply down the server, copy the database to a backup folder, and then restart the database.
Is this possible by coding in VB .net 2003? If not, then any other technique/method you guys can advise? Thanks a lot!
====================
ほんとにどもありがとう!
Rie Ishida
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|