Viewing 15 posts - 4,576 through 4,590 (of 9,241 total)
Can you provide more details around your mirror setup?
What do you mean corrupted?
What are you doing to get the principal back online?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2012 at 3:12 am
The differences between RAID 1+0 and 0+1 are not academic. Let's just review that again, not academic!!!
If you do decide to deploy a 0+1 array for your mission critical data...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2012 at 3:09 am
Sqlsavy (11/23/2012)
We use Litespeed to backup our databases. One particular database grows 330MB/day there is enough space on the data and log drives but I think backup drive will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2012 at 6:37 pm
you never considered raising the Cost threshold for parallelism instead?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2012 at 8:09 am
adb2303 (11/22/2012)
Windows 2008 R2, SQL Server 2008 R2 SP + CU4, multi-instance cluster.
:w00t:
adb2303 (11/22/2012)
32 cores (64 with h/t),
:w00t:
adb2303 (11/22/2012)
384GB per node.
:w00t:
adb2303 (11/22/2012)
Maxdop 4 server wide
??
Why dont you just...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2012 at 8:02 am
TheSQLGuru (11/21/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2012 at 10:10 am
SQLCrazyCertified (11/21/2012)
Ohk....thanks Perry.....didn't know that.SueTons.
Standard only supports full safety, this translates into synchronous mode
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2012 at 10:05 am
SQLCrazyCertified (11/21/2012)
shohelr2003 (11/21/2012)
Thank you, so nothing to be worried.
You should also see next to the principal db says "synchronized"
Since you have witness server, I am thinking, you configured with synchronize...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2012 at 7:46 am
you could build your own using my handy guide at these links
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2012 at 5:36 am
Mani-584606 (11/20/2012)
Hi,We have configured log shipping in SQL Server 2008 R2.
Primary Server A has a named instance on port 1234
Secondary Server B has a named instance on port 4321
Are you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2012 at 5:31 am
GilaMonster (11/20/2012)
That should fall into the category of 'common sense'.... not that common sense is all that common. 🙂
yes you would think, but its not uncommon actually 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 2:45 pm
GilaMonster (11/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 1:21 pm
SQLCrazyCertified (11/20/2012)
I was troubleshooting a connectivity issue for a cluster server.
SQL 2k5 on Windows 2k3.
Found an instance is down, manually brought back online. However, I am wondering howcome...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 11:13 am
Commonly a network error, what testing did you perform to ensure the default of 10 secs was sufficient to mitigate potential issues on your network?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 4:37 am
what is the timeout value you are using for this database?
select mirroring_connection_timeout from sys.database_mirroring
where database_id = DB_ID('yourdb')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 4:16 am
Viewing 15 posts - 4,576 through 4,590 (of 9,241 total)