November 27, 2007 at 1:45 pm
We are migrating SQL from 2000 to 2005 before I migrate I want to know all the configuration setting and database size and there physical location.
Can anyone please help me
Nita
November 27, 2007 at 3:09 pm
Nita Reddy (11/27/2007)
We are migrating SQL from 2000 to 2005 before I migrate I want to know all the configuration setting and database size and there physical location.Can anyone please help me
Nita
Nita,
Here are few links to some scripts from the site that you will find useful.
http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/
http://www.sqlservercentral.com/scripts/Miscellaneous/31647/
You can do little search and will find great deal of info.
Good luck on your migration.
To see all the options that you have been configured on your Sql server 2000, run in QA
exec sp_configure 'show advanced options',1
RECONFIGURE
go
exec sp_configure
it will give you all the options set in your server.
Good luck in your migration and I hope it helps.
Regards,
Najm
November 28, 2007 at 10:17 pm
one other thing you may want to do before your migration is to use the SQL Advisor. This will give you some ideas of the possible bottlenecks or problems you may run into. Good Luck 🙂
-D-
DHeath
November 29, 2007 at 4:45 am
we did the follwings:
======================
1. Take all the user databases backup
2. Script out all windows and sql logins.
This will help.
"More Green More Oxygen !! Plant a tree today"
November 29, 2007 at 7:52 am
Thanks Everyone
November 30, 2007 at 9:37 am
Nita, do you have any Views that use Top 100% with an order by clause? The ORDER BY clause in these views is not supported in SQL 2005.
You must supply the ORDER BY clause when you make the select statement on the view in your application.
Good Luck
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply