[MS SQL Server] Upgrade from Sql 2003 to Sql 2008 |
| Upgrade from Sql 2003 to Sql 2008 Posted: 09 Jul 2013 11:08 PM PDT Hi,We are planning to upgrade from Sql 2003 to Sql 2008 and I would like to know what needs to be prepared and how to do as I will doing very first time.We have sql 2003 - on windows 2003 server with 4 CPU and 4 GB Memory.We have almost 12 Databases and biggest DB is around 250 GB which is also feed by Replication DB as subscriber and Publisher resides on 3rd party.1) What should be the new hardware and server we should configure?2) What other things we need to consider?3) What's the proper steps to migrate/upgrade DB?Thanks, |
| Posted: 09 Jul 2013 05:03 PM PDT Hi,I found error msg in Error log as below.. SQL Service account not running under domain account. please guide me how to resolve this issues.[code="plain"]The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x5, state: 4. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies[/code]thanksananda |
| Posted: 09 Jul 2013 06:50 PM PDT hi all please help me to create good performance plan for my database.In SQL default maintenance plan are there but my former DBA deployed one small script from the following link http://www.mssqltips.com/sqlservertip/1165/managing-sql-server-database-fragmentation/same query in the above linki am running this query monthly once, but after run the query next 3 to 4 days mt database is very slow and some scheduler are taking more than 5 hours to complete,its normal running time is 30 mins only.can anybody help me to create good maintainance plan.thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment