Viewing 15 posts - 5,641 through 5,655 (of 9,244 total)
Steve Jones - SSC Editor (4/21/2012)
master/model/msdb usually are small enough, with few transactions, so including them with binaries is fine. Tempdb I treat as another user database.
+1, but the only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 8:15 am
balasach82 (4/21/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 5:48 am
evevea (4/20/2012)
For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 5:35 am
Chuck Hottle (4/20/2012)
And it can be slow and require additional space when compared to offline.
The advantage of course is that the table\indexes are still available during the rebuild operation.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 3:18 am
lbrigham (4/20/2012)
synchronous database mirroring (high-performance mode) is supported only by Enterprise Edition
Asynchronous only is supported in Enterprise edition
lbrigham (4/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 3:00 am
SQL server 2008 R2 express edition can only participate in replication as a subscriber!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 2:47 am
meckeard (4/19/2012)
My company will be setting up a clustered instance of SQL server 2k8 r2 on vm's and I wanted to know if anyone had recommendations for a book...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 2:42 am
gmamata7 (4/20/2012)
Thanks Perry.What is the best practice to configure Mount points for SQL Server 2008 R2
You're welcome, if you reference the links in my article there is detail in there...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2012 at 12:58 am
sunny.tjk (4/20/2012)
Is SNAC a.k.a SQL Server Native Client? If yes, can SNAC or SSNC be installed by itself or SQL Server RDBMS needs to be installed as well?
It's installed with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2012 at 12:07 pm
APA0876 (4/20/2012)
So I will need Two different Ips for the two instances
Exactly, you will meed separate IP, network name and disk storage for each instance.
APA0876 (4/20/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2012 at 11:59 am
You need to detail exactly the steps you took and any errors that you received.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 11:52 pm
APA0876 (4/19/2012)
How to proceed with an Active/Active installation. Is there a good guide that I can use?
Yes, the guide you already have 😉
Install a second instance and run the add...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 5:05 pm
Kwisatz78 (4/19/2012)
by having more volumes you can parallel write different log files.
Can you get the admin to clarify exactly what they mean by this?
SpringTownDBA (4/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 2:52 pm
dsohal (4/19/2012)
If we replication do we need to extra servers and licensing,
No more than is required for your Log Shipping scenario
dsohal (4/19/2012)
Do these servers will have differnt name
Unless they're in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 2:29 pm
APA0876 (4/19/2012)
Configure Cluster Quorum settings
That's exactly it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2012 at 2:18 pm
Viewing 15 posts - 5,641 through 5,655 (of 9,244 total)