Esport databases

I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003 server
and SQL server 2000 on a new machine how can transfer the old SQL 6.5
databaes to new SQL server 2000 on a new nachine
--
Yousuf Khan
ProgrammerYou can use several methods.
Backup and restore to newserver or Copy both mdf and ldf file to new server
and attach the database or use DTS.
any more question pls reply
hope this will help
Herbert
"Yousuf" wrote:

> I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003 serve
r
> and SQL server 2000 on a new machine how can transfer the old SQL 6.5
> databaes to new SQL server 2000 on a new nachine
> --
> Yousuf Khan
> Programmer|||Herbert thanks for your reply
can you please write me the exact procedure shifting from old server to new
server with upgraded version I am having Tape Device or can i transfer of
import from 6.5 to 2000
--
Yousuf Khan
Programmer
"Herbert" wrote:
[vbcol=seagreen]
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new serve
r
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
>|||U take full backup to ur local server drive. Copy that backup to new server
and using the All Tasks => restore option restore the DB to new server.
For backup and restore refer BOL
--
Herbert
"Yousuf" wrote:
[vbcol=seagreen]
> Herbert thanks for your reply
> can you please write me the exact procedure shifting from old server to ne
w
> server with upgraded version I am having Tape Device or can i transfer of
> import from 6.5 to 2000
> --
> Yousuf Khan
> Programmer
>
> "Herbert" wrote:
>|||6.5 didn't have mdf files, and the storage format was different from the new
architecture. So copy
db files or backup doesn't work.
SQL2K has an upgrade wizard that can upgrade from 6.5. Or, use DTS.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:CC047EAF-C9A5-4E92-B1E8-4C368296F52E@.microsoft.com...[vbcol=seagreen]
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new serve
r
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
>