March 15, 2010 at 3:04 pm
We have a sql 2000 server with 2 (count 'em, two) databases that need to be upgraded to the sql 2008 level. I'm inclined to backup the databases, uninstall sql 2000, install sql 2008 on the same box, then import\upgrade the databases.
Do you agree with this approach or suggest another one?
Barkingdog
March 15, 2010 at 3:18 pm
If you want migrate to SQL 2008 on same server then, probably your approach is correct. Only thing is you don't have good backout plan, if you have to fail back to old version.
Have Server guys Disable IIS on Application Servers
Set All user dbs to RESTRICTED_USER
Verify no user connections
Disable SQL Agent
Script out DB_Mail profiles
Script out SQL Jobs
Script out Users/Logins
Script out DB_Mail profiles
Save out All DTS packages
Save out All SSIS packages
Script out, Linked Server connections, Operators, Alerts, Proxies.
Full Backup of all DB's
Remove(Script out) All replication, publisher, subscriber and distributor
Shut down the SQL 2000 box
Copy Install files to new server.
Uninstall SQL 2000.
Start SQL 2008 install
Apply latest SP
Restore only user databases (Don't restore System databses)
Run add user connections
Run link_users script
Install DB_Mail profiles from script.
Run script to add link servers
test link servers
Install Operators, Alerts, Proxies from script.
install DTS packages
Install SSIS packages
Install jobs from script
Test at least one job
Run publisher replication script
Run subscriber replication script - If this server is also a subscriber.
re-initialize subscribers.
Run row counts on both publisher and subscriber.
Enable IIS on on application servers.
Test! Test! Test!
March 15, 2010 at 3:18 pm
Have you run upgrade advisor on these databases? Have you tested them on SQL 2008 to ensure nothing breaks?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2010 at 3:20 pm
GTR (3/15/2010)
Have Server guys Disable IIS on Application Servers...
Enable IIS on on application servers.
Um, what?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2010 at 3:43 pm
GilaMonster (3/15/2010)
GTR (3/15/2010)
Have Server guys Disable IIS on Application Servers...
Enable IIS on on application servers.
Um, what?
Because don't want any connections through applications to database server during migration window.
March 15, 2010 at 3:49 pm
So every single SQL Server instance in existence has an application server running IIS through which all application connections come?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2010 at 3:51 pm
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?
Not necessarily, most of them do.
March 15, 2010 at 3:55 pm
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2010 at 3:57 pm
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
I am not telling SQL server machine has IIS application running on the same machine.
March 15, 2010 at 4:00 pm
GTR (3/15/2010)
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
I am not telling SQL server machine has IIS application running on the same machine.
So what are you telling?
Did you consider the implications of having applications servers that are also used for other purposes? What would disabling IIS do to those? Don't come suggesting that in my workplace!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 15, 2010 at 4:02 pm
GTR (3/15/2010)
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
I am not telling SQL server machine has IIS application running on the same machine.
Since when is IIS needed for SQL Server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2010 at 4:05 pm
GTR (3/15/2010)
Have Server guys Disable IIS on Application Servers...
Enable IIS on on application servers.
I would recommend something different than disabling IIS. We typically display a maintenance page and then disable connections to the database zone via firewall for all connections except those necessary for maintenance.
I agree that you don't necessarily want users trying to connect to the database. However, we would never be able to disable all IIS applications because not all of ours touch a database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 4:11 pm
Alvin Ramard (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
I am not telling SQL server machine has IIS application running on the same machine.
So what are you telling?
Did you consider the implications of have applications servers that are also used for other purposes? What would disabling IIS do to those? Don't come suggesting that in my workplace!
Ok, we have only dedicated application servers for business critical database server, I mentioned it in general. May be in your work place your Server Team might Disable IIS on application servers even though they are hosting multiple applications for database migration, not everywhere:-P
March 15, 2010 at 4:14 pm
CirquedeSQLeil (3/15/2010)
GTR (3/15/2010)
Have Server guys Disable IIS on Application Servers...
Enable IIS on on application servers.
I would recommend something different than disabling IIS. We typically display a maintenance page and then disable connections to the database zone via firewall for all connections except those necessary for maintenance.
I agree that you don't necessarily want users trying to connect to the database. However, we would never be able to disable all IIS applications because not all of ours touch a database.
I agree with you Jason, as i said there are application servers only dedicated to database servers, what wrong in disabling them during maintenance while database is offline, does it hurt?
March 15, 2010 at 4:20 pm
GTR (3/15/2010)
CirquedeSQLeil (3/15/2010)
GTR (3/15/2010)
Have Server guys Disable IIS on Application Servers...
Enable IIS on on application servers.
I would recommend something different than disabling IIS. We typically display a maintenance page and then disable connections to the database zone via firewall for all connections except those necessary for maintenance.
I agree that you don't necessarily want users trying to connect to the database. However, we would never be able to disable all IIS applications because not all of ours touch a database.
I agree with you Jason, as i said there are application servers only dedicated to database servers, what wrong in disabling them during maintenance while database is offline, does it hurt?
I have never been in an environment where an application server is dedicated to connect only to the database. There has always been some other application or another connection to a different server from the application pool. It is easier (IMO) to display a maintenance page on the apps that connect to the database server upon which maintenance is being performed.
Besides the applications there also needs to be a method in place to disable direct access to the server. Again, we do this to prevent people from accessing the server during maintenance and creating a bigger headache. If you have to disable it in some other fashion, then it seems like extra effort to disable IIS. Also, it is nice to have a "Maintenance" page displayed on screen if somebody does try to access the application through IIS. Otherwise they get a crud error message and a lot of emails and phone calls start firing off.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply