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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-02-03 : 15:28:09
|
| I restored the database from SQL server 2000 to 2005.The database was restored with 80 compatibility.Can i change it to 90 and what are the effects? Coz my applications are pulling data from SQL server 2000. Does 80 work for database mirroring? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-03 : 15:57:04
|
| changing it to 90 will let you use 90 specific features._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-03 : 16:49:30
|
| >> Does 80 work for database mirroring?No. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-03 : 20:29:32
|
| when I restored database from sql 2000 to 2005 .In 2005 mirroring worked for same database |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-03 : 21:51:49
|
| Got this in BOL:Database mirroring works with any supported database compatibility level. |
|
|
|
mahmoudeissa
Starting Member
1 Post |
Posted - 2008-02-14 : 09:16:01
|
quote:
Originally posted by sodeep
I restored the database from SQL server 2000 to 2005.The database was restored with 80 compatibility.Can i change it to 90 and what are the effects? Coz my applications are pulling data from SQL server 2000. Does 80 work for database mirroring?
you can change compatibility level from 80 to 90 but take care , and do this steps: check all view and procedure, if all objects true keep compatibility level 90 , if has error edit these scripts or return to compatibility level 80Best regards |
|
|
|
|
|
|
compatibility level from 80 to 90