| Author |
Topic |
|
bissa
Starting Member
32 Posts |
 Posted - 2012-04-30 : 14:45:21
|
| I have a backup DB made with SQL 2012, I tried to restore the DB with SQL 2008 but it shows error and can't be restored, is there a way to make the current DB compatable with SQL 2008?Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 14:47:06
|
| you cant restore a high version backup to a lower version DB server. You can do reverse though ie taking backup from sql 2008 and restoring in sql 2012------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
bissa
Starting Member
32 Posts |
Posted - 2012-04-30 : 14:50:55
|
| Is there anything I can do to use my SQL 2012 DB with SQL 2008? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 14:55:08
|
| you cant get the backup created in 2012 restored on a 2008 instance under any conditions. you can restore only on 2012 instance. backups created on earlier version can be restored on any of future versions as they'll get upgraded automatically but vice versa is not possible.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bissa
Starting Member
32 Posts |
Posted - 2012-04-30 : 15:24:04
|
| I want to ask a question, maybe not related to SQL but maybe you can help me.I upgraded my game server SQL to 2012, it was using 2008 R2 before, the game server is more laggy now than before, do you think the SQL 2012 could be the reason for that? Could be limited resources? When I check the ram usage, the server is using 96% of total ram.Thank you for the help |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 15:34:01
|
| how did you do the upgrade? whats your host os?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bissa
Starting Member
32 Posts |
Posted - 2012-04-30 : 15:43:24
|
| I made a new installtion of SQL 2012 server and then I restored the DB to it.OS is windows 2008 server. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-01 : 01:40:50
|
| have you configured the SQL Server 2012 in an optimal way?Are you using the same disk layout?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
bissa
Starting Member
32 Posts |
Posted - 2012-05-01 : 15:54:19
|
| hello jackv, I used the default settings, same as I did with SQL 2008. Maybe SQL2012 got some hidden settings causing some how malfunction?The lag begin to start when there is high load on server. I'm just curious if SQL 2012 could have effect on this issue. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-01 : 23:10:16
|
quote:
Originally posted by bissa
hello jackv, I used the default settings, same as I did with SQL 2008. Maybe SQL2012 got some hidden settings causing some how malfunction?The lag begin to start when there is high load on server. I'm just curious if SQL 2012 could have effect on this issue.
did the server had enough resource as suggested by recommended config for sql 2012------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-02 : 01:27:05
|
| Have you seen any symptoms , such as memory pressure? Have you done some diagnostics during the high load? This could give you some cluesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
SQL 2012 DB- How I can make it compatible SQL 2008