Viewing 15 posts - 1,681 through 1,695 (of 4,745 total)
jvskarthick (6/24/2011)
Nice one. Using the server side trace is there a way we can log the data only for perticular user. like the filter we set on SSMS trace file.Thanks,
JK
Gawd,...
June 24, 2011 at 3:10 pm
beejug1983 (6/23/2011)
The command i issued to take Tail Log backup is :backup log primer to disk='H:\primer.trn' with continue_after_error;
that should have worked. You must have done something else before trashing the...
June 24, 2011 at 8:00 am
The same way I presume you set it to 90, rebuild all indexes specifying a fill factor of 0.
June 23, 2011 at 3:39 pm
info on linked servers is held in master, so a restore of msdb would not recover those.
June 23, 2011 at 2:30 pm
beejug1983 (6/23/2011)
June 23, 2011 at 1:22 pm
what command did you issue for the tail backup? If the .ldf was intact you should have been able to back it up with the no_truncate option.
norecovery would only...
June 23, 2011 at 10:37 am
I do have maintenance plans.
My main concern is making sure the users and sql agent jobs are moved correctly.
I guess for the sql agent jobs, instead of moving msdb...
June 23, 2011 at 9:35 am
you can restore the msdb database but it can quickly become messy.
I would definitely advise against it if you use maintenance plans unless you delete them before the move,
If you...
June 23, 2011 at 9:12 am
there is no direct upgrade path.
you will need to install a clustered sql instance on top of a windows cluster.
June 23, 2011 at 6:55 am
sounds like the service pack to me.
the latest is SP4 in which case if this is 64bit you want file
SQLServer2005SP4-KB2463332-x64-ENU.exe
from site http://www.microsoft.com/download/en/details.aspx?id=7218
June 23, 2011 at 6:52 am
sql2k8 (6/22/2011)
Process sqlservr
Private Bytes 82026496.000
Working Set 46809088.000
Are you referring...
June 22, 2011 at 10:09 am
opc.three (6/22/2011)
george sibbald (6/22/2011)
that setting covers just the buffer pool, there is also proc cache, locks, connections.
I'll add to the list of non-buffer-pool memory used by SQL Server: memory used...
June 22, 2011 at 10:07 am
Viewing 15 posts - 1,681 through 1,695 (of 4,745 total)