|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > 6.5 attach dat file from different server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
6.5 attach dat file from different server
|
|
| Stefan 2002-12-19, 11:23 am |
| I got a dat file from a different server. I have to access the
database in this file. I have no idea how the database name is and
which tables are in that database.
I tried it that way:
- create a new database
- shutdown
- exchange the .dat files
- restart
However, SQl Server fails on starting the database.
Any help is gratly appreciated.
Stefan
| |
| Stefan 2002-12-19, 11:23 am |
| Sfefan,
I haven't used them while I was running 6.5, but theoretically, this can be
done with DISK REININT and DISK REFIT commands. Check BOL for more
information.
"Stefan" <stefan.gabriel@koelliker.de> wrote in message
news:7739ddd8.0212190839.39e83d38@posting.google.com...
> I got a dat file from a different server. I have to access the
> database in this file. I have no idea how the database name is and
> which tables are in that database.
>
> I tried it that way:
> - create a new database
> - shutdown
> - exchange the .dat files
> - restart
>
> However, SQl Server fails on starting the database.
>
> Any help is gratly appreciated.
>
> Stefan
| |
| Tibor Karaszi 2002-12-20, 5:23 am |
| .... and consider having MS PSS handhold you though the process. This is (can be) quite an
involved topic, even if you are an expert on the old SQL Server architecture.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Stefan" <st@mailnot.com> wrote in message news:ejI3NH4pCHA.1616@TK2MSFTNGP10...
> Sfefan,
>
> I haven't used them while I was running 6.5, but theoretically, this can be
> done with DISK REININT and DISK REFIT commands. Check BOL for more
> information.
>
> "Stefan" <stefan.gabriel@koelliker.de> wrote in message
> news:7739ddd8.0212190839.39e83d38@posting.google.com...
> > I got a dat file from a different server. I have to access the
> > database in this file. I have no idea how the database name is and
> > which tables are in that database.
> >
> > I tried it that way:
> > - create a new database
> > - shutdown
> > - exchange the .dat files
> > - restart
> >
> > However, SQl Server fails on starting the database.
> >
> > Any help is gratly appreciated.
> >
> > Stefan
>
>
|
|
|
|
|