Viewing 15 posts - 7,561 through 7,575 (of 9,253 total)
Jeffrey Williams-493691 (10/15/2010)
timscronin (10/15/2010)
if the log is growing that large because you are rebuilding all of your indexes every night
as a side note, if you rebuild indexes in simple recovery...
October 16, 2010 at 7:55 am
daveb87 (10/15/2010)
I think it is a good practice to backup the Master, MSDB and Model databases on a regular basis.
It's vitally important!!
daveb87 (10/15/2010)
October 16, 2010 at 7:14 am
Not much to say here that's not already been said really!
My own experiences are with various systems including Shabba's environment where i worked on the design\deployment.
This has to be...
October 16, 2010 at 7:01 am
I'm with Gail on this WHY???
Having said that, to delete a row without using DELETE simply requires an UPDATE which nullifies any column data. OK the row isn't actually deleted,...
October 16, 2010 at 5:37 am
Geoff A (10/15/2010)
make sure the SQL Server Browser service is running.
This is not required when specifying the ip address and port!
October 15, 2010 at 6:55 am
Regardless, you would be well advised to backup all system databases as a set. If you ever had to restore you would certainly want MSDB and Master to be in...
October 15, 2010 at 3:26 am
In SQL Server 2008 the only system database moved to a cluster node local drive (the SQL Binn directory) is the MSSQLSystemResource database. This is to facilitate, as far as...
October 15, 2010 at 3:15 am
Hmm looks correct, that's the format I use
192.X.X.X,port
Have you set a static tcp port for the named instance or is it still set to dynamic?
Also have you checked the event...
October 15, 2010 at 12:25 am
Yes and how are you specifying the IP and port number, what are you typing into the connection dialog box?
October 14, 2010 at 1:55 pm
October 14, 2010 at 9:55 am
there is also a bug in the failover cluster install whereby you elect to install shared component files to D:\program files\MSSQL instead of C:
you go to your next node and...
October 14, 2010 at 9:48 am
Jpotucek (10/13/2010)
What I want to do is bring SQL Server down while they do the actual server backups
Take all SQL Server resource groups offline, this will offline all the...
October 14, 2010 at 9:30 am
Jpotucek (10/14/2010)
Do you think I should only take the Cluster Group offline
No that would disable access to the cluster! This group will go offline when the last cluster node shuts...
October 14, 2010 at 9:03 am
Are we talking windows 2003 or 2008 cluster here?
October 14, 2010 at 7:58 am
try posting on the MSDN forums may help.
October 14, 2010 at 7:36 am
Viewing 15 posts - 7,561 through 7,575 (of 9,253 total)