Viewing 15 posts - 7,546 through 7,560 (of 9,241 total)
please do not double post, you already have a thread on this subject in the appropriate forum.
Replies to http://www.sqlservercentral.com/Forums/Topic1005872-1549-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2010 at 1:36 pm
do you have a separate computer or are you installing your mirror instance on the same machine as the principal?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2010 at 12:16 pm
Steve Jones - SSC Editor (10/16/2010)
Of course, that limits the size of the host, and then the VMs
This, I suspect, is the key here!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2010 at 8:28 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2010 at 1:55 pm
Found it, it's fixed in SP1 CU10. This link[/url] details the issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2010 at 9:30 am
Viewing 15 posts - 7,546 through 7,560 (of 9,241 total)