Viewing 15 posts - 4,576 through 4,590 (of 9,244 total)
sanath.kumar.kura (11/26/2012)
The log file is grown to five times the database size.
Transaction Log file size 3.1GB
Database file size is 700 MB
Recovery Model : Full
backup strategy : Daily full database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 4:37 am
shohelr2003 (11/23/2012)
Now for some reason I wanna restore database to my principal from another databse.Will it cause any inconsistency in mirror databse?
Yes, of course the databases will be totally...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 1:27 am
Follow my guide at these links
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2012 at 4:56 am
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
Viewing 15 posts - 4,576 through 4,590 (of 9,244 total)