Newbie: How do I register a "local" database?

I have copied a "SQL Server" folder onto my disk from another computer.
Now I want to register this server. How do I do that? I think it may be a
question of what the name of it is. The folder that I copied onto my
computer is MSSQL$VBdotNET and the original server was on another computer
as "computer_name\VBdotNet. The reason for my copying this folder is that
the original disk is intact but cannot be booted so I can't use any of the
SQL Server tools to copy the database.
TIA,
Larry WoodsWhat you should be doing is simply copy the MDF and LDF files, and using
sp_attachdb. You can't just copy an entire SQL Server installation and
expect it to run... it needs to be installed. But you can easily copy the
database files, assuming SQL Server came down gracefully.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Larry Woods" <larry@.lwoods.com> wrote in message
news:#GXHA2a0EHA.3820@.TK2MSFTNGP11.phx.gbl...
> I have copied a "SQL Server" folder onto my disk from another computer.
> Now I want to register this server. How do I do that? I think it may be
a
> question of what the name of it is. The folder that I copied onto my
> computer is MSSQL$VBdotNET and the original server was on another
computer
> as "computer_name\VBdotNet. The reason for my copying this folder is that
> the original disk is intact but cannot be booted so I can't use any of the
> SQL Server tools to copy the database.
> TIA,
> Larry Woods
>|||Do you actually have SQL Server installed on your PC? Once you have
installed the software you can use sp_attach_db to attach a database file to
the server (assuming the database file(s) are what you copied over). See
Books Online for details on sp_attach_db.
--
David Portas
SQL Server MVP
--|||It looks like I will have to just add the databases to another server. What
I had done was to copy the folder that included the "data" folder, which
included all of the mdf/ldf files for the server. I had hoped that I could
somehow "install" the server.
Guess not, huh?
Thanks
Larry Woods
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:pradnWCX5bGQVj7cRVn-qw@.giganews.com...
> Do you actually have SQL Server installed on your PC? Once you have
> installed the software you can use sp_attach_db to attach a database file
to
> the server (assuming the database file(s) are what you copied over). See
> Books Online for details on sp_attach_db.
> --
> David Portas
> SQL Server MVP
> --
>|||Thanks, Aaron,
This is what I started to do but I had hoped that I could "preserve" the old
server.
No such luck, right?
Larry Woods
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ONiFoXb0EHA.4004@.tk2msftngp13.phx.gbl...
> What you should be doing is simply copy the MDF and LDF files, and using
> sp_attachdb. You can't just copy an entire SQL Server installation and
> expect it to run... it needs to be installed. But you can easily copy the
> database files, assuming SQL Server came down gracefully.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Larry Woods" <larry@.lwoods.com> wrote in message
> news:#GXHA2a0EHA.3820@.TK2MSFTNGP11.phx.gbl...
> > I have copied a "SQL Server" folder onto my disk from another computer.
> > Now I want to register this server. How do I do that? I think it may
be
> a
> > question of what the name of it is. The folder that I copied onto my
> > computer is MSSQL$VBdotNET and the original server was on another
> computer
> > as "computer_name\VBdotNet. The reason for my copying this folder is
that
> > the original disk is intact but cannot be booted so I can't use any of
the
> > SQL Server tools to copy the database.
> >
> > TIA,
> >
> > Larry Woods
> >
> >
>|||You need to install the software from the distribution disc first.
--
David Portas
SQL Server MVP
--|||Larry,
SQL Server is like most other software in terms of installation. You
can't just copy it on and hope it works. If you copied Microsoft office
from the CD it wouldn't work, you need to *install* it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Larry Woods wrote:
> It looks like I will have to just add the databases to another server. What
> I had done was to copy the folder that included the "data" folder, which
> included all of the mdf/ldf files for the server. I had hoped that I could
> somehow "install" the server.
> Guess not, huh?
> Thanks
> Larry Woods
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:pradnWCX5bGQVj7cRVn-qw@.giganews.com...
>>Do you actually have SQL Server installed on your PC? Once you have
>>installed the software you can use sp_attach_db to attach a database file
> to
>>the server (assuming the database file(s) are what you copied over). See
>>Books Online for details on sp_attach_db.
>>--
>>David Portas
>>SQL Server MVP
>>--
>>
>
>