Monday, March 12, 2012

How to create a new serverinstance but with old datafiles?

Hi group
I want to make a new serverinstance, but based on some old files from a
previous instance I once had from a SQL I scrapped.
I only know how to use the SQL Server enterprise manager console, and I
haven't found any tools in there to do that.
Any suggestion will be more than welcome.

AdrianYou can try to reattach the old database file using sp_attach_db or with
Enterprise Manager. This may not work of the old databases weren't cleanly
detached, though.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Adrian Hjelmslund" <anonymous@.nothing.com> wrote in message
news:KniUd.357$mj1.135@.news.get2net.dk...
> Hi group
> I want to make a new serverinstance, but based on some old files from a
> previous instance I once had from a SQL I scrapped.
> I only know how to use the SQL Server enterprise manager console, and I
> haven't found any tools in there to do that.
> Any suggestion will be more than welcome.
> Adrian

No comments:

Post a Comment