Viewing 15 posts - 6,781 through 6,795 (of 9,253 total)
which hyper visor are you using?
August 23, 2011 at 5:50 am
MarvinTheAndriod (8/23/2011)
I am shrinking the log file. When scripted out it comes up with the command line:DBCC SHRINKFILE (N'HCMPRD88_Data' , 0, TRUNCATEONLY)
it looks like youre trying to shrink the log...
August 23, 2011 at 5:20 am
MarvinTheAndriod (8/23/2011)
Perry Whittle (8/23/2011)
are you referring to the option to release ununsed space in the database shrink dialog?Yes this the option, im looking at
Are you shrinking the database or an...
August 23, 2011 at 5:12 am
are you referring to the option to release ununsed space in the database shrink dialog?
August 23, 2011 at 5:02 am
check the Windows application event log for messages
August 23, 2011 at 3:58 am
yes, terminal services does not affect sql server agent jobs
August 23, 2011 at 3:39 am
Erik Hansson (8/23/2011)
August 23, 2011 at 3:28 am
roughly how many rows do you delete, update, insert?
If you dont absolutely need to clear the whole table then dont use the truncate, the truncate will be fast but the...
August 23, 2011 at 3:23 am
Loner (8/22/2011)
If I use data mirroring, would it be better?
no, you cannot update the mirror unless you failover to it, but then its no longer a warm standby!
August 22, 2011 at 2:04 pm
Ronnie Jones (8/22/2011)
August 22, 2011 at 2:02 pm
Dj463 (8/22/2011)
I mean if standalone instance name is SQL123 and IP 10.1.2.12, Then can i install a clustered instance on the same...
August 22, 2011 at 1:56 pm
Dj463 (8/22/2011)
is there any way to keep the instance name same as the previous standalone instance?
if the stand alone server and the new cluster are in different domains then yes!
August 22, 2011 at 9:08 am
GilaMonster (8/22/2011)
that is part of the buffer pool and is constrained by max memory.
is that correct? Although part of the same overall memory pool that is constrained by the max...
August 22, 2011 at 9:05 am
do you have any Windows server level backup jobs running at all (BackupExec, etc)?
August 22, 2011 at 8:25 am
Install the SSRS components on the remote server, if you want to store the SSRS databases on the cluster then select the clustered instance during the SSRS reporting configuration.
If...
August 22, 2011 at 8:19 am
Viewing 15 posts - 6,781 through 6,795 (of 9,253 total)