RE: moving SQL 7 DB in 6.0 compatibility Level onto SQL2000
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 01/20/05
- Next message: Mike Epprecht (SQL MVP): "RE: HELP"
- Previous message: BoB Teijema: "Linked Server: WHERE clause not being executed"
- In reply to: danmartin1969: "RE: moving SQL 7 DB in 6.0 compatibility Level onto SQL2000"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 Jan 2005 04:37:02 -0800
Hi
I can't verify if the FTP link works from here, but Microosft PSS will be
able to give you access to it.
Regards
Mike
"danmartin1969" wrote:
> This question is kinda unrelated to the previous ones but this is probably
> the best place to post it. I am currently upgrading from SQL 7 to SQL 2000
> and get the error
> Error running script: messages.sql(1). I have found that I need s80305i.exe
> but the link on Microsofts website is either broken or has changed. I am
> unable to retrieve the .exe. Does anyone know where I may be able to find
> it. My email if need be is dan.martin@ccpace.com. Thanks in advance.
> "Mike Epprecht (SQL MVP)" wrote:
>
> > Hi
> >
> > Backup and Restore for SQL 7.0 works well, even with 6.0 compatability
> > level. Once the DB is restored, re-build all the indexes and statistics. Then
> > run a DBCC CHECKDB to verify the consistency of the DB.
> >
> > Regards
> > Mike
> >
> > "J Hotch" wrote:
> >
> > > Hi there, i'm planning an upgrade of some DB's currently sitting on a SQL7
> > > server to a new SQL2000 server. some of these DB's are running in 6.0
> > > compatibility level and this cant (for reasons i wont go into here) be
> > > changed. the others are 7.0 level and can be changed to 8.0.
> > >
> > > what is the best way to get all of my DB's onto the new server? the 6.0 DB's
> > > are up to 170gig, whilst the 7.0 DB's are up to 200gig. does the
> > > compatibility level have any impact when moving to 2000? i.e. will SQL2000
> > > NOT accept a DB running in 6.0 level, to be moved onto it?(i am aware of the
> > > post migration issues with commands etc, but i'm currently concerned with the
> > > actual migration issues)
> > >
> > > I'm currently thinking of either restoring from Backup or using a DTS package?
> > >
> > > all recomendations apreciated.
- Next message: Mike Epprecht (SQL MVP): "RE: HELP"
- Previous message: BoB Teijema: "Linked Server: WHERE clause not being executed"
- In reply to: danmartin1969: "RE: moving SQL 7 DB in 6.0 compatibility Level onto SQL2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
