One quick question. Is "upgrating SQL7 to SQL2K on NT4.0" any different than "upgrating SQL7 to SQL2K on WIN2K" ??

What are the impacts, if they are different? Please do let...

If you use DBArtisan, You can do this very well with Migrate option.

DTS would surely let you copy the database.

You CANNOT use "Transfer Database Task".

But you can use "Copy SQL Server Objects Task". You can either append the data or...

Nice to know this way Jeremy.

I has similar problem, and been using DBArtisan table dependencies page for this.

If you use DBArtisan, this is even simpler.

Yes. I agree. I do the same.

John,

I apologise for the dumb question... But what does TSM, ARC means??

I am sorry.. Its by Steve Jones.

You could also check this article by Andy:

http://www.sqlservercentral.com/columnists/sjones/whoownsthatdatabase.asp

try like this...

exec xp_cmdshell'dir D:\"Program Files"\ > d:\d_200304021.txt'

DUMP DATABASE OLDDBNAME TO DISK='D:\DBA\DBDUMPS\OLDDBNAME_DBDUMP_20030402.DMP'

GO

RESTORE DATABASE NEWDBNAME FROM DISK='D:\DBA\DBDUMPS\OLDDBNAME_DBDUMP_20030402.DMP' WITH MOVE 'OLDDBNAME' TO 'c:\test\NEWDBNAME.mdf',

MOVE 'OLDDBNAME_log' TO 'c:\test\NEWDBNAME.ldf'

GO

Hope this Helps!!!

Regards,

Murali.

Giving a thought to that aspect, I think we can get reduce the pages/sec by reducing the fill factor.

Any Thoughts!!!!

Please check if "SQL Server Agent --> Properties (Connection Tab) has "Use Windows Authentication" option checked.

Hope this Helps!!!

Yes. I agree with racosta that we have to concentrate on INSERTS only. But I think we should lower it to minimise the work on the SQL Server on page...

You can check all the support dates on the following page. I have recently received this link from Microsoft Tech Support for the same question.

http://support.microsoft.com/default.aspx?id=fh;en-us;lifeprods%5B/url%5D

Edited by -...