Mary
It would be worth you looking up sp_help_revdatabase.
You need to recreate the database with exactly the same structure
(fragments) as before. sp_help_revdatabase run against the original db
creates a script by analysing the existing database. You can then use this
script to recreate the new database structure.

Another potential problem occurs if you intend to copy the logins as well.
The syslogins table is in the master database therefore the SUIDs generated
when you create a new login will be different on your new server. The SUID
is a foreign key in the sysusers table for each database the login has
access to so the suids must match properly.
Hope this helps.
Caroline Charles


> ----------
> From: Mary Bahrami[SMTP:[Email Address Removed] Sent: 07 June 2002 19:06
> To: SQLDBA (E-mail)
> Subject: Sql Server 6.5 copy database?
>
> All,
>
> We have a 6.5 database that we can't upgrade right now. It has never
> been restored. I want to test restoring it to another server. I have
> only done this in SQL Server 2000.
>
> So far, I have just installed nt4.0 and SS6.5 SP5 on the test server. I
> have a backup the the database that was created via a Sql Server backup
> job. (a .dat file)
>
> I think my steps are:
>
> 1.create the database on the test server (I have to recreate the
> devices, since it is not automatic in 6.5, but the drives will be
> different, is that okay? so I am going to do sp_helpdevice to get the
> layout from the production database?)
> 2. do a restore from the menu? hopefully I can point at the file I ftp'd
> over?
>
>
> Can you confirm that this will work, or what am I missing?
>
> Thanks,
> Mary
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]


____________________________________________________________________
"This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. This communication may contain material protected by
attorney-client privilege. If you are not the intended recipient or
the person responsible for delivering the email to the intended
recipient, be advised that you have received this email in error and
that any use, dissemination, forwarding, printing, or copying of this
email is strictly prohibited. If you have received this email in error
please notify the IT Call Centre by telephone on 44 (0) 1953 608000."

[Email Address Removed]MS Sql Server LazyDBA home page