Viewing 15 posts - 1,411 through 1,425 (of 9,244 total)
Manic Star (2/4/2016)
Manic Star (2/2/2016)
We've experimented with DPMProbably the worst product I've ever had the misfortune to use
LOL, yep. Altho VEEAM was worse. Veeam made our failover cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 10:04 am
alex.sqldba (2/4/2016)
I might be in the wrong forum here, but let's see.
I am building a 4 Node cluster for AlwaysOn Availability Groups - this is a shared nothing cluster....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 7:46 am
KJP (2/2/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 7:32 am
you're using an expression to pass to the Arguments property, is that correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 7:11 am
gary1 (2/3/2016)
I want to move only user databases to new mount points.
Providing the answer to my last post is Yes, read this article[/url] for info on moving database files in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 5:16 am
gary1 (2/3/2016)
Currently, installation and System databases are default location E:\Microsoft SQL Server\MSSQL10_50.SP\MSSQL\DATA
and these are not moving, correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 5:14 am
ramana3327 (2/3/2016)
This is not cluster.Is it ok to change to X86 in the installation media and run the upgrade? It should work right
just again to reiterate, No it won't!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 5:08 am
dembis (2/2/2016)
I have many databases pointing their transaction logs to a same location (G: drive in my case). I would like to reduce the size of G: thru vmware...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 5:07 am
kenny 40254 (2/3/2016)
I'm sure that the originating vendor of the solution we are log shipping from (and the customer) have no coordinated backup strategy....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 5:03 am
how much memory does the server have?
how much granted to sql server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 3:57 am
jacksonandrew321 (2/2/2016)
Hi how to check space in primary and secondary file groups after and before moving indexes from primary to secondary .
SET NOCOUNT ON
SELECTdf.name AS LogicalFileName
, ISNULL(fg.name, 'Log') AS FilegroupName
,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 8:45 am
ramana3327 (2/2/2016)
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
Planning to upgrade to SQL 2008r2.
Do we need to select processor Type...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 8:39 am
gary1 (2/2/2016)
Hi,We currently have a 2 node active/passive cluster setup in production. Now we want to move to mount points.
Just the user databases you are moving?
gary1 (2/2/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 8:15 am
Mike Hinds (2/3/2016)
Perry Whittle (2/1/2016)
curious_sqldba (2/1/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 8:08 am
this gets certs too, with a little work you can expand to get symm and asymm keys too
SET NOCOUNT ON
DECLARE @sql NVARCHAR(MAX)
DECLARE @majver INT
DECLARE @minver INT
DECLARE @build VARCHAR(16)
SET @sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 7:19 am
Viewing 15 posts - 1,411 through 1,425 (of 9,244 total)