Re: attaching DAT files

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 15:28:34 +0100

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
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> >
> >
>
>

Relevant Pages

  • Re: attaching DAT files
    ... use DUMP and LOAD, go for that. ... DUMP DATABASE ... > After REFIT stop and start SQL server service. ...
    (microsoft.public.sqlserver.server)
  • Re: attaching DAT files
    ... use DUMP and LOAD, go for that. ... DUMP DATABASE ... > After REFIT stop and start SQL server service. ...
    (microsoft.public.sqlserver)
  • Re: Optimization of data migration
    ... You would load the data to a staging DB, ... > something equivalent when migrating to SQL Server? ... > database and copy the data "as is" in a staging database. ...
    (microsoft.public.sqlserver.dts)
  • Re: any tool which can tell the load of each database running on a SQL
    ... Did you mean Load in terms of User connections for each databases, ... This will give you the amount of users in each database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • 6.5 to 6.5
    ... I want to upgrade our 6.5 sql server to sql server 2000 but first I ... This way when I screw the pooch I ... Anyway I was planning on creating a new database and then restore it ... with a dump from the original. ...
    (microsoft.public.sqlserver.server)
Loading