Re: sqlserver 6.5 never backup

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 10:42:18 +0530

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

Relevant Pages

  • Re: SCO 5.0.5 dd / clone
    ... > have implemented a dd cloning of the master hard disk to a backup disk. ... > or master disk and the clone or backup disk. ...
    (comp.unix.sco.misc)
  • Re: Sizing up Disks with Shadowing
    ... Not as soon as the initial shadow copy is ready at least, ... the master. ... member being added to a 2 member set), data is read from either of the two ... place without the need to lock disk blocks or block I/O, ...
    (comp.os.vms)
  • Re: [opensuse] Does anyone know about disk master password
    ... requires the master password. ... If the disk is protected by password and you ... there is no way to reset password ... Carlos is right in that reading the man page for hdparm is good place ...
    (SuSE)
  • Re: Cannot recover the master database.
    ... To fix a corrupted master database run rebuildm.exe. ... msdb and modle databases and replace them with blank ones. ... You do have a backup of your system databases, ...
    (microsoft.public.sqlserver.server)
  • Re: Installing 360 games
    ... actual code in the data portion of the disk to be any different. ... But how would this work - you'd need a unique master for each 'unique' ... Pressing relies on making an exact duplicate of the master - you're ... literally 'pressing' the glass master onto the blank disc to make an ...
    (uk.games.video.misc)