Viewing 15 posts - 1,591 through 1,605 (of 4,745 total)
DBCC memorystatus but good luck with that. 🙂
August 2, 2011 at 11:04 am
The 58Gb is just Buffer cache. On top of that you have such things as proc cache, memory for locks, user connections........
August 2, 2011 at 10:43 am
........(and it wasn't their fault in the first place - some idiot developers had dug up a few metres of underground phone line). .
How do you know it wasn't the...
August 1, 2011 at 3:05 pm
peter Vramby (7/5/2011)
July 30, 2011 at 3:02 pm
just add a file to the filegroup. SQL will automatically start writing to the new file. It writes in a round robin proportional fill basis., i.e it writes more to...
July 29, 2011 at 2:41 pm
You don't say if the new server will have the same name?
unless you have a large number of SSIS packages stored in msdb and scheduled as jobs, recreating logins, jobs,...
July 29, 2011 at 1:46 pm
bear in mind that as model is used a s the template for database creation, if you change the model database to simple recovery model all new databases will be...
July 28, 2011 at 8:21 am
related to an SSIS job by any chance?
Our resolution for this after speaking to MS was to disable the TCP chimney on the SQL server and any clients initiating the...
July 27, 2011 at 3:42 pm
if you are running this process from a remote machine using SSIS TCP chimney needs to be disabled on that machine as well.
July 27, 2011 at 3:32 pm
Interesting. I have certainly never come across any technical information that alludes to this behaviour. To my mind the documentation leads you to think the restore of model would be...
July 26, 2011 at 8:57 am
GilaMonster (7/25/2011)
george sibbald (7/25/2011)
GilaMonster (7/25/2011)
TRaceflag 3608Start the SQL Server from the command line in single user, restricted more and with that traceflag
SQLServr.exe -m -f -T3608
I don't believe that will work...
July 26, 2011 at 8:11 am
GilaMonster (7/25/2011)
TRaceflag 3608Start the SQL Server from the command line in single user, restricted more and with that traceflag
SQLServr.exe -m -f -T3608
I don't believe that will work Gail. Only the...
July 25, 2011 at 3:18 pm
A failed backup will not break the log chain.
But why are you trying to force on your clients where they backup to? Let them decide for themselves, which would normally...
July 25, 2011 at 3:06 pm
OS error code 5 means access denied. This is a permissions error.
Make sure the account you are using has access to the directory and to the file itself
July 22, 2011 at 1:41 pm
The question does specifically say SQL208 and for sa.
For any SQL authenticated account I get 1900-01-01, for windows accounts I get NULL
July 21, 2011 at 6:50 am
Viewing 15 posts - 1,591 through 1,605 (of 4,745 total)