**** Post for FREE via your newsreader at post.usenet.com ****
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
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.usenet.com...
> **** Post for FREE via your newsreader at post.usenet.com ****
> 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
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> 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.usenet.com...
> > **** Post for FREE via your newsreader at post.usenet.com ****
> >
> > 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
> >
> >
> >
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=> > *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> > http://www.usenet.com
> > Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>|||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...
> > 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.usenet.com...
> > > **** Post for FREE via your newsreader at post.usenet.com ****
> > >
> > > 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
> > >
> > >
> > >
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=> > > *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> > > http://www.usenet.com
> > > Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=> >
> >
>
Showing posts with label dat. Show all posts
Showing posts with label dat. Show all posts
Monday, February 13, 2012
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
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Sunday, February 12, 2012
Attaching 6.5 db files
Hello everyone,
I'm in a situation with a 3rd party where they have 3 .dat files (no log fil
es) from a SQL 6.5 database. These files were located on a backup tape from
2001. The client would like to make this database operational again. The
master.dat file was not rec
overable, nor was the log file. Is there any way to "attach" these files so
we can ultimately upgrade to SQL 2000? Any input would be appreciatedYou would need a 6.5 installation to begin with. Then you would either use
LOAD ("restore") if the DAT file is a backup file (produced with DUMP) or
use DISK REINIT and DISK REFIT if it is a database file (which I'm sure
requires all the database devices that constituted the database).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike" <mjucht@.neb.rr.com> wrote in message
news:E27B27A7-F299-473A-A816-42C757AE8330@.microsoft.com...
> Hello everyone,
> I'm in a situation with a 3rd party where they have 3 .dat files (no log
files) from a SQL 6.5 database. These files were located on a backup tape
from 2001. The client would like to make this database operational again.
The master.dat file was not recoverable, nor was the log file. Is there any
way to "attach" these files so we can ultimately upgrade to SQL 2000? Any
input would be appreciated|||Mike
You can not attach SQL 6.5 databases, it was not a feature available at that
time.
If you have the dat files you may be able to restore the database to a SQL S
erver 6.5 installation and then upgrade. Although you only have .dat files y
ou may have the logs, in 6.5 you do not have to seperate the data and logs s
o the .dat files may contai
n both.
However even if you do have the entire database in the files you have, you s
till will not be able to restore the database unless you build it exactly li
ke it was. What this means is that say you had a 300mb 6.5 database that was
created as 100mb and expan
ded by 100mb twice. You would need to create an empty database in exactly th
e same way before you could restore it.
The best way to restore a 6.5 database is to have the output from sp_help_re
vdatabase available. I don't suppose you have that do you?
Hope this helps
John|||I'm reading up on the DISK REINIT command and it states the SIZE parameter m
ust be identical to how the device was originally created. Is there any way
to tell how the device was originally created without the master.dat? I'm
afraid the answer is "no" b
ut if you have any ideas I'd appreciate them.
Thanks,
Mike
-- Tibor Karaszi wrote: --
You would need a 6.5 installation to begin with. Then you would either use
LOAD ("restore") if the DAT file is a backup file (produced with DUMP) or
use DISK REINIT and DISK REFIT if it is a database file (which I'm sure
requires all the database devices that constituted the database).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike" <mjucht@.neb.rr.com> wrote in message
news:E27B27A7-F299-473A-A816-42C757AE8330@.microsoft.com...
> Hello everyone,
files) from a SQL 6.5 database. These files were located on a backup tape
from 2001. The client would like to make this database operational again.
The master.dat file was not recoverable, nor was the log file. Is there any
way to "attach" these files so we can ultimately upgrade to SQL 2000? Any
input would be appreciated|||You have the physical file size, and can go on that!
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike" <mjucht@.hotmail.com> wrote in message
news:ECC5EA3A-2283-45A5-87A6-F29156BD01B4@.microsoft.com...
> I'm reading up on the DISK REINIT command and it states the SIZE parameter
must be identical to how the device was originally created. Is there any
way to tell how the device was originally created without the master.dat?
I'm afraid the answer is "no" but if you have any ideas I'd appreciate them.
> Thanks,
> Mike
> -- Tibor Karaszi wrote: --
> You would need a 6.5 installation to begin with. Then you would
either use
> LOAD ("restore") if the DAT file is a backup file (produced with
DUMP) or
> use DISK REINIT and DISK REFIT if it is a database file (which I'm
sure
> requires all the database devices that constituted the database).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Mike" <mjucht@.neb.rr.com> wrote in message
> news:E27B27A7-F299-473A-A816-42C757AE8330@.microsoft.com...
(no log
> files) from a SQL 6.5 database. These files were located on a backup
tape
> from 2001. The client would like to make this database operational
again.
> The master.dat file was not recoverable, nor was the log file. Is
there any
> way to "attach" these files so we can ultimately upgrade to SQL 2000?
Any
> input would be appreciated
>
>
I'm in a situation with a 3rd party where they have 3 .dat files (no log fil
es) from a SQL 6.5 database. These files were located on a backup tape from
2001. The client would like to make this database operational again. The
master.dat file was not rec
overable, nor was the log file. Is there any way to "attach" these files so
we can ultimately upgrade to SQL 2000? Any input would be appreciatedYou would need a 6.5 installation to begin with. Then you would either use
LOAD ("restore") if the DAT file is a backup file (produced with DUMP) or
use DISK REINIT and DISK REFIT if it is a database file (which I'm sure
requires all the database devices that constituted the database).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike" <mjucht@.neb.rr.com> wrote in message
news:E27B27A7-F299-473A-A816-42C757AE8330@.microsoft.com...
> Hello everyone,
> I'm in a situation with a 3rd party where they have 3 .dat files (no log
files) from a SQL 6.5 database. These files were located on a backup tape
from 2001. The client would like to make this database operational again.
The master.dat file was not recoverable, nor was the log file. Is there any
way to "attach" these files so we can ultimately upgrade to SQL 2000? Any
input would be appreciated|||Mike
You can not attach SQL 6.5 databases, it was not a feature available at that
time.
If you have the dat files you may be able to restore the database to a SQL S
erver 6.5 installation and then upgrade. Although you only have .dat files y
ou may have the logs, in 6.5 you do not have to seperate the data and logs s
o the .dat files may contai
n both.
However even if you do have the entire database in the files you have, you s
till will not be able to restore the database unless you build it exactly li
ke it was. What this means is that say you had a 300mb 6.5 database that was
created as 100mb and expan
ded by 100mb twice. You would need to create an empty database in exactly th
e same way before you could restore it.
The best way to restore a 6.5 database is to have the output from sp_help_re
vdatabase available. I don't suppose you have that do you?
Hope this helps
John|||I'm reading up on the DISK REINIT command and it states the SIZE parameter m
ust be identical to how the device was originally created. Is there any way
to tell how the device was originally created without the master.dat? I'm
afraid the answer is "no" b
ut if you have any ideas I'd appreciate them.
Thanks,
Mike
-- Tibor Karaszi wrote: --
You would need a 6.5 installation to begin with. Then you would either use
LOAD ("restore") if the DAT file is a backup file (produced with DUMP) or
use DISK REINIT and DISK REFIT if it is a database file (which I'm sure
requires all the database devices that constituted the database).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike" <mjucht@.neb.rr.com> wrote in message
news:E27B27A7-F299-473A-A816-42C757AE8330@.microsoft.com...
> Hello everyone,
files) from a SQL 6.5 database. These files were located on a backup tape
from 2001. The client would like to make this database operational again.
The master.dat file was not recoverable, nor was the log file. Is there any
way to "attach" these files so we can ultimately upgrade to SQL 2000? Any
input would be appreciated|||You have the physical file size, and can go on that!
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike" <mjucht@.hotmail.com> wrote in message
news:ECC5EA3A-2283-45A5-87A6-F29156BD01B4@.microsoft.com...
> I'm reading up on the DISK REINIT command and it states the SIZE parameter
must be identical to how the device was originally created. Is there any
way to tell how the device was originally created without the master.dat?
I'm afraid the answer is "no" but if you have any ideas I'd appreciate them.
> Thanks,
> Mike
> -- Tibor Karaszi wrote: --
> You would need a 6.5 installation to begin with. Then you would
either use
> LOAD ("restore") if the DAT file is a backup file (produced with
DUMP) or
> use DISK REINIT and DISK REFIT if it is a database file (which I'm
sure
> requires all the database devices that constituted the database).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Mike" <mjucht@.neb.rr.com> wrote in message
> news:E27B27A7-F299-473A-A816-42C757AE8330@.microsoft.com...
(no log
> files) from a SQL 6.5 database. These files were located on a backup
tape
> from 2001. The client would like to make this database operational
again.
> The master.dat file was not recoverable, nor was the log file. Is
there any
> way to "attach" these files so we can ultimately upgrade to SQL 2000?
Any
> input would be appreciated
>
>
Subscribe to:
Posts (Atom)