Script for Database Creation??

Hello,
I know how to make scripts for tables and indexes and
other objects, but how do I make a script to create the
actual database?
I have a database with multiple filegroups, etc. and I
would really like to setup a script to recreate it but I
cannot figure out how.
Thanks.
Chris.One way is in QA, Object Browser, right-click the database and do the
scripting from there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Chris" <stooky@.geekadventure.com> wrote in message
news:85bc01c40428$6d042e50$a501280a@.phx.gbl...
> Hello,
> I know how to make scripts for tables and indexes and
> other objects, but how do I make a script to create the
> actual database?
> I have a database with multiple filegroups, etc. and I
> would really like to setup a script to recreate it but I
> cannot figure out how.
> Thanks.
> Chris.|||Sweet, thanks. I was poking around here...there,
downloaded EMS...etc...etc.
Thanks.
Chris.
>--Original Message--
>One way is in QA, Object Browser, right-click the
database and do the
>scripting from there.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Chris" <stooky@.geekadventure.com> wrote in message
>news:85bc01c40428$6d042e50$a501280a@.phx.gbl...
>> Hello,
>> I know how to make scripts for tables and indexes and
>> other objects, but how do I make a script to create the
>> actual database?
>> I have a database with multiple filegroups, etc. and I
>> would really like to setup a script to recreate it but I
>> cannot figure out how.
>> Thanks.
>> Chris.
>
>.
>|||Hi,
One more way is using Enterprise manager,
In Enterprise Manager, Right click above the database which you need the
script
select ALL tasks and select "Generate SQL Scripts"
In the Options Tab -- Select (Click) "Script database"
Go back to General Tab and click "Preview"
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eHGOysCBEHA.1140@.TK2MSFTNGP10.phx.gbl...
> One way is in QA, Object Browser, right-click the database and do the
> scripting from there.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Chris" <stooky@.geekadventure.com> wrote in message
> news:85bc01c40428$6d042e50$a501280a@.phx.gbl...
> > Hello,
> >
> > I know how to make scripts for tables and indexes and
> > other objects, but how do I make a script to create the
> > actual database?
> >
> > I have a database with multiple filegroups, etc. and I
> > would really like to setup a script to recreate it but I
> > cannot figure out how.
> >
> > Thanks.
> >
> > Chris.
>