How to take the database online/ bring it offline by command prompt?

Hi,
I now using MS SQL SERVER Desktop Edition, as I know there is no enterpirse
belongs with this edition. I would like to perform a task that is provided
in the enterprise manager.
The task is "select a database--rightclick->All Tasks-->Taks Offline/Bring
Online"
The database file will then disconnect and connect to the server.
Anybody know how to perform the same task by command prompt as there is no
enterprise manager?
Thanks
RC
Hi,
From OSQL use the below commands:-
For Offline
ALTER DATABASE <DBNAME> SET OFFLINE
For Online
ALTER DATABASE <DBNAME> SET ONLINE
Note:
You have many options in ALTER DATABASE command, refer books online for more
information.
THanks
Hari
SQL Server MVP
"RC" <rc@.gmail.com> wrote in message
news:u2q2ST%23PFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I now using MS SQL SERVER Desktop Edition, as I know there is no
> enterpirse
> belongs with this edition. I would like to perform a task that is provided
> in the enterprise manager.
> The task is "select a database--rightclick->All Tasks-->Taks Offline/Bring
> Online"
> The database file will then disconnect and connect to the server.
> Anybody know how to perform the same task by command prompt as there is no
> enterprise manager?
> Thanks
> RC
>