Re: sql developer needing advice from sql server (6.5) admin guys

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

Date: Wed, 10 Mar 2004 17:48:14 +0100

Robert,

Restore (LOAD) was no trivial process in the old architecture. The basics
are that you first need to create the database, *having the correct
structure* (same as it had when you took the backup) and then you can use
the LOAD command to do the restore. In order to do this, you need to get
your hands on the original installation and run sp_help_revdevice. The
output from this will assist you in how to create the database devices and
later the database (allocating storage in the correct way from these
database devices) on the destination server. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Robert" <robert@robert-payne.demon.co.uk> wrote in message
news:204064f9.0403100829.52f5fe56@posting.google.com...
> I have tried looking though previous postings but can't really get a
> handle on the problem
> I have an old 6.5 backup file which I would love to migrate up my
> present sql server 2000. I have installed an evaluation copy of 6.5
> inorder to start the process but am having no luck. So I would like to
> pose a couple of questions which might help me on my way.
> 1. When I look into the backup file the first word is 'TAPE' then the
> usual garbage. Is this right for a backup file? Also the file has no
> extention to the file name - is this right?
> 2. My sql server 6.5 reports no space to create a new database from
> the backup/restore dialogue boxes. Am I right in thinking that this
> might be the cause for the 'Restore Now' button being greyed out when
> I try to restore the above file?
> Sorry about the rambling nature of this question but I experience of
> sql server has really only been from the language angle.
> Any help/suggestions would be very welcome
> Rob
Quantcast