Viewing 15 posts - 1 through 15 (of 51 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...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
January 6, 2016 at 2:44 am
how valid is this statement ?
Totally invalid
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
January 6, 2016 at 2:05 am
Here is a useful thread
http://www.sqlservercentral.com/Forums/Topic120198-71-1.aspx
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
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
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
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...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 9, 2015 at 3:03 am
jacksonandrew321 (12/4/2015)
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 4, 2015 at 3:34 am
Check out this article
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 4, 2015 at 3:30 am
glad you resolved it
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 4, 2015 at 1:44 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...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
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?...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 3, 2015 at 9:00 am
Here is a good article
https://technet.microsoft.com/en-gb/library/cc731739.aspx
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 2, 2015 at 1:46 am
best practice
rename sa account
Disable login
Just as you would on a windows server, rename the built-in local administrator account
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 27, 2015 at 2:30 am
https://technet.microsoft.com/en-us/library/ms190640%28v=sql.110%29.aspx
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 25, 2015 at 4:57 am
NBU definitely uses msdb. Here is an nice article
http://www.sqlhammer.com/blog/discovery-symantec-netbackup/
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 25, 2015 at 3:54 am
stan.kappiris (11/19/2015)
As others have suggested, do yourself a...
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 25, 2015 at 2:08 am
Viewing 15 posts - 1 through 15 (of 51 total)