copying sql server 6.5 to another machine

Hi All,
It is with great sadness that I am posing this question. I have been
assigned a task to copy the contents from one existing sql server 6.5 to a
new machine. I know .. I know.. its going to be a pain. I know its not
supported and all that. I can't find any article that explains how I can
copy databases and logins and all the pertinent information from one existing
server to a new machine.
Does anyone have any information on it? I would greatly appreciate it since
my knowledge of sql 6.4 is minimal.
Thanks in advance,
sqlgirl
Is it possible for you to have the same directory structure on the both machines?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlgirl" <sqlgirl@.discussions.microsoft.com> wrote in message
news:82C7C7C3-C332-4494-8630-E3B4C54B9976@.microsoft.com...
> Hi All,
> It is with great sadness that I am posing this question. I have been
> assigned a task to copy the contents from one existing sql server 6.5 to a
> new machine. I know .. I know.. its going to be a pain. I know its not
> supported and all that. I can't find any article that explains how I can
> copy databases and logins and all the pertinent information from one existing
> server to a new machine.
> Does anyone have any information on it? I would greatly appreciate it since
> my knowledge of sql 6.4 is minimal.
> Thanks in advance,
> sqlgirl
|||yes.. its possible to get the same directory structure.
The only problem is old server is NT 4.0.
the new one is Windows 2000 server.
Our ultimate goal is to use this new server as a test server to upgrade sql
6.5 to sql 2000.
Thanks
"Tibor Karaszi" wrote:

> Is it possible for you to have the same directory structure on the both machines?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sqlgirl" <sqlgirl@.discussions.microsoft.com> wrote in message
> news:82C7C7C3-C332-4494-8630-E3B4C54B9976@.microsoft.com...
>
|||If you have the same directory structure, you could try:
Installing SQL Server on the new machine.
Stop both SQL Servers
Copy *all* the database device files to the new machine. Put in same directory as on the source
machine. Default extension for database device file pre-7 is .DAT.
Start the new SQL Server.
sp_dropserver and sp_addserver on the new machine so that sysservers in master is correct (read
about the LOCAL option for sp_addserver).
The last thing now would be your Windows logins. The mapping you have done in SQL Security Manager
is stored in some (to me) secret place. So you might need to re-create the Windows logins (this
mapping) using SQL Security Manager. I'm vague on this point as I haven't touched 6.5 for many
years now.
Above method is not supported. Supported method is backup/restore which is far from as easy as it is
in the new architecture. Test thoroughly. Hire a consultant with 6.5 experience if that makes you
sleep better.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlgirl" <sqlgirl@.discussions.microsoft.com> wrote in message
news:EBC0B769-A304-4C1E-9096-24E1FFAB7DF6@.microsoft.com...[vbcol=seagreen]
> yes.. its possible to get the same directory structure.
> The only problem is old server is NT 4.0.
> the new one is Windows 2000 server.
> Our ultimate goal is to use this new server as a test server to upgrade sql
> 6.5 to sql 2000.
> Thanks
> "Tibor Karaszi" wrote:
|||Hi,
To add on to the valuable informations from Tibor; Ensure that you install
the same service pack in both the server.
Prefered SQL 6.5 service pack is SP5a + Post SP5a update.
But try to upgrade your SQL Server version to 2000. If you have compatibiily
issues then upgrade the 6.5 database to 2000 and
keep your user databases compatibily level to 6.5
See sp_dbcmptlevel in SQL 2000 books online
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:esGmtSooFHA.1412@.TK2MSFTNGP09.phx.gbl...
> If you have the same directory structure, you could try:
> Installing SQL Server on the new machine.
> Stop both SQL Servers
> Copy *all* the database device files to the new machine. Put in same
> directory as on the source machine. Default extension for database device
> file pre-7 is .DAT.
> Start the new SQL Server.
> sp_dropserver and sp_addserver on the new machine so that sysservers in
> master is correct (read about the LOCAL option for sp_addserver).
> The last thing now would be your Windows logins. The mapping you have done
> in SQL Security Manager is stored in some (to me) secret place. So you
> might need to re-create the Windows logins (this mapping) using SQL
> Security Manager. I'm vague on this point as I haven't touched 6.5 for
> many years now.
> Above method is not supported. Supported method is backup/restore which is
> far from as easy as it is in the new architecture. Test thoroughly. Hire a
> consultant with 6.5 experience if that makes you sleep better.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sqlgirl" <sqlgirl@.discussions.microsoft.com> wrote in message
> news:EBC0B769-A304-4C1E-9096-24E1FFAB7DF6@.microsoft.com...
>
|||> Ensure that you install the same service pack in both the server.
> Prefered SQL 6.5 service pack is SP5a + Post SP5a update.
Good thinking, Hari!
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%232goMHpoFHA.2472@.tk2msftngp13.phx.gbl...
> Hi,
> To add on to the valuable informations from Tibor; Ensure that you install the same service pack
> in both the server.
> Prefered SQL 6.5 service pack is SP5a + Post SP5a update.
> But try to upgrade your SQL Server version to 2000. If you have compatibiily issues then upgrade
> the 6.5 database to 2000 and
> keep your user databases compatibily level to 6.5
> See sp_dbcmptlevel in SQL 2000 books online
>
> Thanks
> Hari
> SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:esGmtSooFHA.1412@.TK2MSFTNGP09.phx.gbl...
>
|||Hi
As far as I remember, SQL Server 6.5 is not supported on Windows 2000. Only
up to NT4.0
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sqlgirl" <sqlgirl@.discussions.microsoft.com> wrote in message
news:EBC0B769-A304-4C1E-9096-24E1FFAB7DF6@.microsoft.com...[vbcol=seagreen]
> yes.. its possible to get the same directory structure.
> The only problem is old server is NT 4.0.
> the new one is Windows 2000 server.
> Our ultimate goal is to use this new server as a test server to upgrade
> sql
> 6.5 to sql 2000.
> Thanks
> "Tibor Karaszi" wrote:
|||Hmm, I'm pretty sure I had 6.5 running on my W2K pro machine. Doesn't mean it was supported, though
(important distinction). I know for sure I couldn't make it install on XP. I don't remember whether
6.5 was/is supported on W2K, so running something where which isn't supported anymore where the
config wasn't even supported to begin with probably isn't a good idea...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uTXZAuqoFHA.1872@.TK2MSFTNGP10.phx.gbl...
> Hi
> As far as I remember, SQL Server 6.5 is not supported on Windows 2000. Only up to NT4.0
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "sqlgirl" <sqlgirl@.discussions.microsoft.com> wrote in message
> news:EBC0B769-A304-4C1E-9096-24E1FFAB7DF6@.microsoft.com...
>
|||Mike Epprecht (SQL MVP) (mike@.epprecht.net) writes:
> As far as I remember, SQL Server 6.5 is not supported on Windows 2000.
> Only up to NT4.0
I'm pretty sure that SQL 6.5 SP5a was supported. In any case I do have
6.5 running on Windows 2000.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp