Viewing 7 posts - 16 through 22 (of 22 total)
SQL 2012 version compatibility level is 110. Please check.
For your situation you can restore a database from sql 2008 to sql 2012. then change the compatibility level to 110. If...
March 9, 2015 at 2:15 pm
The maxdop setting is relavant to the number of processors
8 or less processors ===> 0 to N (where N= no. of processors)
More than 8 processors ...
March 9, 2015 at 1:35 pm
Check the Database consistency; If it is ok then Doing a Backup and Restore is the perfect option and then change the compatibility to 110.
March 9, 2015 at 7:59 am
I included in the 6th step pre-migration check list.
March 9, 2015 at 7:48 am
Since there is no much high availability needed in the environment I suggest set a backup and restore job every night specifying the paths of the database. That would be...
March 6, 2015 at 10:47 am
Those are windows service accounts.
February 26, 2015 at 1:57 pm
use the import/export wizard on ssms.
February 26, 2015 at 1:49 pm
Viewing 7 posts - 16 through 22 (of 22 total)