Viewing 15 posts - 3,811 through 3,825 (of 9,241 total)
Ginga (12/31/2013)
We have a server that needs more memory but we've hit the 32GB limit imposed by Windows Server 2008 R2 Standard. We plan to perform an in place...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 3:14 am
WebTechie38 (1/2/2014)
I am trying to document the environment I am working at.
I want to document our clustered servers.
1) Server Name
2) Virtual Server Name
3) Primary node name
4) ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:47 am
So you're replicating the database storage drives at the storage level, no HA on the Windows or SQL level, correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:33 am
For more on moving database files in SQL Server see my guide at this link[/url], now to the issue at hand
ramana3327 (1/2/2014)
use test_copy
alter database test_copy
MODIFY FILE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:25 am
JimS-Indy (1/2/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:08 am
niver (1/2/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 1:04 am
darklight_arizona (1/2/2014)
You mean to say we put all the system databases (like master, msdb, temdb etc)
on a shared disk and these databases are common to both the nodes.
Active...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 12:56 am
Grant Fritchey (1/2/2014)
100% true. But, you probably wouldn't be asking about where to put storage if you had no choice in the matter.
Sure, about the only time is when migrating...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 7:07 am
Krishna1 (4/9/2013)
DECLARE @bc INT;
DECLARE @ec INT;
DECLARE @bfn VARCHAR(1000);
DECLARE @efn VARCHAR(10);
-- Get the name of the current default trace
SELECT @filename = CAST(value AS NVARCHAR(1000))
FROM ::fn_trace_getinfo(DEFAULT)
WHERE traceid = 1 AND...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 6:44 am
Follow this knowledge base article from MS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 6:24 am
JoshDBGuy (12/30/2013)
and need to replicate/mirror/copy/log ship to another server in the cloud.
First thing to do is to decide on which you will use sounds like you have thought about it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 5:50 am
Grant Fritchey (1/2/2014)
If you want faster performance for the system databases, you might consider local storage.
Unless its an FCI then you are required to use shared storage not local
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 5:42 am
Right click the table and select "Script table as" > "Create to" > "New query editor window".
Do you see the default constraint script there?
Please post results of the following query
SELECTdc.nameAS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 5:05 am
are you referring to database mirroring?
You cannot mirror system databases. If you have installed a failover clustered instance of sql server, the system databases will be on shared drives that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 4:33 am
when you mention filetables are you referring to filestream objects?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2013 at 5:48 am
Viewing 15 posts - 3,811 through 3,825 (of 9,241 total)