attaching DAT files

**** Post for FREE via your newsreader at post.mcse.ms ****
Hello,
I have solved my problem with connecting to SQL 6.5. Thank you for
answering.
Still I have two more questions.
I have copied DAT file from one computer with SQL 6.5 and put it to another
computer with SQL 6.5. How can I attach this file to database on second
computer? This file seems to beDatabase Device's file, and this is not a
backup. I have no chances to do a backup from first computer. Only I have is
Dat files from C:\MSSQL\DATA folder. Is there any solution?
And second question. I can see three database devices on my MSSQL 6.5
server. How do I know which device's databases I see?
Thank you.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=You need to use DISK REINIT and DISK REFIT. Read about the commands in Books
Online...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:40487d61$1@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello,
> I have solved my problem with connecting to SQL 6.5. Thank you for
> answering.
> Still I have two more questions.
> I have copied DAT file from one computer with SQL 6.5 and put it to
another
> computer with SQL 6.5. How can I attach this file to database on second
> computer? This file seems to beDatabase Device's file, and this is not a
> backup. I have no chances to do a backup from first computer. Only I have
is
> Dat files from C:\MSSQL\DATA folder. Is there any solution?
> And second question. I can see three database devices on my MSSQL 6.5
> server. How do I know which device's databases I see?
> Thank you.
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Hi,
In SQL 6.5 it is always better to take a DUMP of the database and then copy
it to destination and Load it
1. DUMP DATABASE
2. COPY the DMP file to destination
3. LOAD DATABASE
In SQL 6.5 the commands Tiber mentioned can be used during worst cases,
Normally when master database is damaged and
incomplete master database is incomplete. This case you have the physical
files. Each physical files (DAT files)can be mapped to
sysdevices table using DISK REINIT command. After that run DISK REFIT to
recreate the SYSUSAGES table.
After REFIT stop and start SQL server service.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OQJeohrAEHA.232@.TK2MSFTNGP10.phx.gbl...
> You need to use DISK REINIT and DISK REFIT. Read about the commands in
Books
> Online...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Darius" <darius.ram@.takas.lt> wrote in message
> news:40487d61$1@.post.mcse.ms...
> another
have
> is
>|||I just want to add that I fully agree with Hari. If you have the option to
use DUMP and LOAD, go for that. What we nowadays call detach and attach was
no fun thing in the old architecture...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OVXHN1rAEHA.688@.tk2msftngp13.phx.gbl...
> Hi,
> In SQL 6.5 it is always better to take a DUMP of the database and then
copy
> it to destination and Load it
> 1. DUMP DATABASE
> 2. COPY the DMP file to destination
> 3. LOAD DATABASE
> In SQL 6.5 the commands Tiber mentioned can be used during worst cases,
> Normally when master database is damaged and
> incomplete master database is incomplete. This case you have the physical
> files. Each physical files (DAT files)can be mapped to
> sysdevices table using DISK REINIT command. After that run DISK REFIT to
> recreate the SYSUSAGES table.
> After REFIT stop and start SQL server service.
> Thanks
> Hari
> MCDBA
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OQJeohrAEHA.232@.TK2MSFTNGP10.phx.gbl...
> Books
second
a
> have
>|||**** Post for FREE via your newsreader at post.mcse.ms ****
Hello,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OQJeohrAEHA.232@.TK2MSFTNGP10.phx.gbl...
> You need to use DISK REINIT and DISK REFIT. Read about the commands in
Books
> Online...
I have done everything as explained in example, but I encountered errors
such as "can't open file" or "start server with -m options". I don't know
what to do? There is no way to get a database dump. I have only *.dat files
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||As I said, this is not simple in the old architecture. All information that
is needed *is* available in Books Online. However, if you still encounter
problems, I recommend that you hire a consultant who know how to do this or
open a case with MS Support to assist you with this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404c35d1@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OQJeohrAEHA.232@.TK2MSFTNGP10.phx.gbl...
> Books
> I have done everything as explained in example, but I encountered errors
> such as "can't open file" or "start server with -m options". I don't know
> what to do? There is no way to get a database dump. I have only *.dat
files
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=