Viewing 15 posts - 511 through 525 (of 1,524 total)
I wouldn't restore MSDB froM SQL2008 to 2012.... I am sure there are table changes between the two different versions of SQL Server....
Man that is a LOT of jobs.... ...
February 14, 2014 at 6:48 am
Understood... but...
I started being a SQL Server DBA here in 1996... started working with Oracle in 2003 until about 2008 then went back to focusing only on SQL Server and...
February 10, 2014 at 11:26 am
I have been here in IT for over 20 years and came here right out of college. I started as a data entry operator and steadily have moved up...
February 10, 2014 at 10:50 am
calvo (2/7/2014)
Just saw Fernando Rodney is close to a deal with the Mariners. This makes me wonder, does his crooked hat bother anyone else?
Not a fan of it.. but.. to...
February 7, 2014 at 10:58 am
It depends... and they can...
If you look at the version of the security update and the version of the Service pack if the version of the security patch is...
February 6, 2014 at 6:51 am
I am not a fan of the cloud for business stuff. How do you guarantee they are backing it up, its integrity is good, when they do a 'change'...
February 6, 2014 at 6:40 am
I remember that article as well. Back in year 2000 we had 4 SQL Server databases.... Today we have 50 Prod SQL Servers running over 300 databases and...
January 29, 2014 at 7:12 am
When you say it is doing all of its work but always stopping... what do you mean by always stopping?
January 28, 2014 at 8:13 am
I like the idea of Service Packs. A roll up of further tested CUs bundled together. My guess is they are moving resources away from creating SPs and...
January 28, 2014 at 8:04 am
There is a fine balance of young talent and veteran talent that can take a club to the playoffs. There is also luck... or unlucky as well... injuries can...
January 27, 2014 at 10:43 am
well... if you don't have a unique index on any of the tables you cannot setup replication... also... not sure if you can replicate from SQL2008 to 2000.... probably can......
January 23, 2014 at 6:46 am
As far as moving master, model and msdb there is no need to move them unless you want to. They are hardly used so moving them is more of...
January 23, 2014 at 6:33 am
I have always heard you should 'size' your database to about the size it should grow to for 1 years worth of data. Autogrowth should be not small chunks. ...
January 23, 2014 at 6:28 am
Keep in mind while the index build is running queries against that data will be stopped... or vice versa as well.
The bigger the table the longer it will take to...
January 23, 2014 at 6:24 am
I assume you are moving from one server to another, current one running SQL2008 and the new one running SQL2008R2...
Yes, db backups are easily restored from SQL2008 to 2008R2 without...
January 23, 2014 at 6:22 am
Viewing 15 posts - 511 through 525 (of 1,524 total)