Viewing 15 posts - 1 through 15 (of 50 total)
Hugo Kornelis (1/6/2016)
mark.williams 37494 (1/6/2016)
how valid is this statement ?
Totally invalid
But that does not mean that maintenance jobs are great. They are not. They allow you to do some pretty...
January 6, 2016 at 2:44 am
how valid is this statement ?
Totally invalid
January 6, 2016 at 2:05 am
Here is a useful thread
http://www.sqlservercentral.com/Forums/Topic120198-71-1.aspx
December 10, 2015 at 9:22 am
richardmgreen1 (12/10/2015)
I'm assuming the new servers will be on the Business Intelligence Edition.If my assumption is correct, will mirroring work?
Yes, mirroring is a feature of the BI edition
December 10, 2015 at 3:47 am
Just because you have created a login this doesn't mean the login has any access to databases, you need to give those permissions via "user mappings" in the properties of...
December 9, 2015 at 3:03 am
jacksonandrew321 (12/4/2015)
December 4, 2015 at 3:34 am
Check out this article
December 4, 2015 at 3:30 am
The AUTO_CLOSE option is probably enabled for the databases that SQL Server is regularly restarting. AUTO_CLOSE closes the database when the last user closes his or her connection and all...
December 3, 2015 at 9:07 am
Velveeta22 (12/3/2015)
GilaMonster (6/8/2009)
"G:\Data\MSSQL\Database.mdf".
"G:\Data\MSSQL\Data\Database_log.ldf"
Do these files exist?...
December 3, 2015 at 9:00 am
best practice
rename sa account
Disable login
Just as you would on a windows server, rename the built-in local administrator account
November 27, 2015 at 2:30 am
NBU definitely uses msdb. Here is an nice article
November 25, 2015 at 3:54 am
stan.kappiris (11/19/2015)
As others have suggested, do yourself a...
November 25, 2015 at 2:08 am
Viewing 15 posts - 1 through 15 (of 50 total)