August 1, 2002 at 10:34 am
Hi All,
One of our MFG sites uses SQL Server 7.0, and they've FTP'd the database to us so we could use it for reference (read-only, we won't be updating). Problem is, we have SQL Server 2000 at our site. I assume that I can't just RESTORE or ATTACH a 7.0 DB to 2000, or can I? Has anyone had to do this, and knows what to expect?
Also, from what I've read, I might have to run this command to fix orphaned users:
sp_change_users_login 'Auto_Fix', '%' (According to Sharon Dooley's book). Question #2 is, if we are only using the DB to look at data for reference, do we need to fix orphaned users? None of the users from that location will use our DB here.
OK! That's enough for one post, I think. Please note that I'm actually a VB Developer (I'm ducking) who's falling in love FAST with SQL Server Administration and Design, and this is my first real administrative task.
THANK you!
Edited by - paulie_decesare on 08/01/2002 10:35:53 AM
August 1, 2002 at 10:47 am
I believe you can restore or attach a SQL 7 database, but you'd have to try. Can't hurt.
You do not need to run "sp_change..." unless you need the users. You can add new users, just as long as the names don't conflict with existing users.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 1, 2002 at 10:49 am
That's what I was hoping. Thanks!
quote:
I believe you can restore or attach a SQL 7 database, but you'd have to try. Can't hurt.You do not need to run "sp_change..." unless you need the users. You can add new users, just as long as the names don't conflict with existing users.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply