Viewing 15 posts - 8,566 through 8,580 (of 9,253 total)
GilaMonster (12/31/2008)
Full backup's not going to fix the problems the shrink caused,
Gail, i see where Paresh has gone with this. He advises that after truncating the log and breaking...
December 31, 2008 at 8:02 am
Dugi (12/31/2008)
ps (12/31/2008)
we dont have double post. we've 5 posts on the same topic!!
Yes I can see for that reason I told Steve that the SSC board should have more...
December 31, 2008 at 3:27 am
also remembering from another of your posts,
did you set the "lock pages in memory" policy on this server?
December 30, 2008 at 4:23 pm
BTW nice script Jeff
December 30, 2008 at 4:09 pm
dholland (12/30/2008)
Just checked:
Microsoft SQL Server Management Studio9.00.1399.00
That is SP1. My server is on SP2, let me...
December 30, 2008 at 4:06 pm
DBADave (12/30/2008)
TREND - Anti-virus (not real-time)CSA - Cisco Security Agent
Double-Take - Replication to Disaster Recovery server
great, bound to be a few memory leak issues with that little lot installed.
you dont...
December 30, 2008 at 4:00 pm
you need to size the log file appropriately to handle transactions between backups.
what is the recovery model of the database set to at the moment?
December 30, 2008 at 1:08 pm
oh dear madhu you are in a pickle arent you.
what do you have min and max memory set to on node 1?
have you thought about setting up a sql trace...
December 30, 2008 at 12:54 pm
what does the following query return on the server you are having problems on?
select @@servername
it sounds as though the sql instance cannot be verified and hence it thinks no service...
December 30, 2008 at 12:46 pm
have you tried opening the job remotely through SSMS on another machine?
December 30, 2008 at 12:31 pm
a compatibility version of 80 doesnt mean you can restore the database back to sql2000.
as previously pointed out you would be well advised to make sure that both environments use...
December 30, 2008 at 10:35 am
interesting links, so basically if it all went horribly wrong and 1 file filled up for some reason all the data would be written to just 1 remaining data file....
December 30, 2008 at 10:22 am
Richard Hall (12/29/2008)
December 30, 2008 at 10:05 am
Steve's topic at the following link should get you started
http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/
also check out Brad McGehee's topics on this subject. A google search should provide the link for that
December 30, 2008 at 4:05 am
installs as a named instance if sql is already on the machine. Re run the setup and select Analysis Services
December 29, 2008 at 4:34 pm
Viewing 15 posts - 8,566 through 8,580 (of 9,253 total)