SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL 2000 databases compatibility mode on SQL 2008		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rikleo2001
Posting Yak Master

New Zealand
180 Posts
Posted - 07/19/2012 :  10:35:13  Show Profile  Send rikleo2001 a Yahoo! Message  Reply with Quote
Guys

I 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

USA
4967 Posts
Posted - 07/19/2012 :  12:22:28  Show Profile  Visit russell's Homepage  Reply with Quote
Should be no worries with any of those. Proceed as normal.
Go to Top of Page

rikleo2001
Posting Yak Master

New Zealand
180 Posts
Posted - 07/20/2012 :  05:20:59  Show Profile  Send rikleo2001 a Yahoo! Message  Reply with Quote
Thank for quick reply..

Seriously there is no issues in maintenance of these database via SQL 2008 new processes?

SKR
Go to Top of Page

sql-lover
Yak Posting Veteran

54 Posts
Posted - 07/25/2012 :  00:55:11  Show Profile  Reply with Quote
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.
Go to Top of Page

rikleo2001
Posting Yak Master

New Zealand
180 Posts
Posted - 07/25/2012 :  05:18:23  Show Profile  Send rikleo2001 a Yahoo! Message  Reply with Quote
Ok, thanks for the reply and confirmation.

SKR
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000