Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2012-07-19 : 10:35:13
|
| GuysI am planning to put SQL 2000 database on SQL Server 2008 in SQL 2000 Compatibility mode, I believe it should work as I tested it.My questions are .1. In terms of database administration what would be the challenges to maintain the database? like index re-build via SQL 2008 plan? update stats? etc..2. Any issues in terms of applying security patches etc...More around DBA maintenance side any risks we need to worry about?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-07-19 : 12:22:28
|
| Should be no worries with any of those. Proceed as normal. |
 |
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2012-07-20 : 05:20:59
|
| Thank for quick reply..Seriously there is no issues in maintenance of these database via SQL 2008 new processes?SKR |
|
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-07-25 : 00:55:11
|
quote:
Originally posted by rikleo2001
Thank for quick reply..Seriously there is no issues in maintenance of these database via SQL 2008 new processes?SKR
Basically, the compatibility mode affects how TSQL is parsed in statements.In terms of maintenance (no code) should not be a problem. However, please keep in mind that some SQL 2008 system views may not work. Also, please update your statistics after the upgrade. |
|
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2012-07-25 : 05:18:23
|
| Ok, thanks for the reply and confirmation.SKR |
|
|
|
|
|
|
SQL 2000 databases compatibility mode on SQL 2008