Re: sqlserver 6.5 never backup

From: Greg Linwood (g_linwoodQhotmail.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 17:11:27 +1000

Hi Hari

You don't necessarily need the master to use disk reinit / refit - you just
need to be able to work out the device sizes which is possible if you have
the files..

Regards,
Greg Linwood
SQL Server MVP

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:eA0g$rqeEHA.396@TK2MSFTNGP12.phx.gbl...
> Hi Greg,
>
> I agree with you, the reason is that DISK REINIT and DISK REFIT can only
be
> used if your
> Master database comes up perfectly or you have a damaged master and then
you
> restore the old master dump which
> do not conatin the full sysdevices and sysusages entries. (he do not have
> master dump as well)
>
> One more thing is that both the commands are very complicated (as you
> mentioned)
> to use with out knowing the entire device structure.
>
>
>
>
> Tahnks
> Hari
> MCDBA
>
>
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:#NEoizpeEHA.4092@TK2MSFTNGP10.phx.gbl...
> > This certainly isn't the only way. The documented approach is to use
DISK
> > REINIT / DISK REFIT. These are written up in the old 6.5 books online,
> which
> > unfortunately I don't have handy but William should given he's using
6.5.
> > It's certainly not straight forward though as it requires you to
calculate
> > the device size manually which in turn is not easy. Hari's approach is
> > potentially easier.
> >
> > William, given that Hari answered a similar thread from you two days
ago,
> > perhaps you should respond to his answer & at least let him know whether
> you
> > tried what he suggested & whether it worked or not. I'd be interested
too.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
> > news:usFPMmpeEHA.3612@TK2MSFTNGP12.phx.gbl...
> > > Hi William,
> > >
> > > This is the only way if you do not have the backup.
> > >
> > > If you have all the Physical DAT files , including Master database
> device
> > .
> > > Then all you have to do is..
> > >
> > > 1. Take a copy of all DAT files to a safe location
> > > 2. Install SQL 6.5 in the same folder as old installation
> > > 3. apply the same service pack as old
> > > 4. stop sql server and sql executive
> > > 5. Copy all the DAT files to the same folder
> > > 6. Start SQl server and SQL executive service.
> > >
> > > Now your SQl server will be back as old.
> > >
> > > Note:
> > >
> > > Now onwards please prepare and backup strategy to backup your
databases.
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > > "william.huang" <william.huang@saturn.yzu.edu.tw> wrote in message
> > > news:OuuZwLpeEHA.1356@TK2MSFTNGP09.phx.gbl...
> > > > If my Sql server 6.5 never backup and operating system was destroy
> > > > what I got is only the Dat file , Could I use any method to save
them
> > > > back.
> > > > thanks.
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Loading