Viewing 15 posts - 3,361 through 3,375 (of 9,241 total)
The fact that there is an ALTER statement to achieve this should assure you it's a supported action 😉
Internally within the system, filegroups are referenced by their allocated id "data_space_id"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2014 at 5:06 am
I'm astounded, after picking myself up off the floor in amazement let's look closer
Francis Apel
Probably the biggest reason someone would choose to cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2014 at 4:37 am
Microsoft introduced the ability to modify user database file paths for a very good reason, so you don't have to detach databases.
Whilst it may seem a good idea I'd prefer...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2014 at 9:32 am
mlwiller2 (4/14/2014)
But yeah its x86. Both SQL (standard) and windows server 2003 (standard) are 32bit versions.
Unfortunately, with Windows 2003 Standard 32 bit the OS will not support more than 4GB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2014 at 2:18 pm
balasach82 (4/11/2014)
SQL 2008
For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2014 at 2:08 pm
Lynn Pettis (4/12/2014)
Port1433 (4/12/2014)
I can't grasp the meaning of instance as it is being used in various contexts. For example SQL SERVER 2000,SQL server 2005, SQL Server 2008 and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2014 at 12:17 pm
I think what you're asking is can you 2 separate Availability groups. Yes you can. What are you trying to achieve though?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2014 at 7:31 pm
although the restore job says its successful, check the history of each individual step, there'll be an error message there somewhere 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2014 at 6:15 am
sheeraz.khan (4/11/2014)
Dear Team,I will really appreciate if you could share the role/requirement of primary and secondary replica under SQL Server 2012 AlwaysOn.
Thanks.
Simple really, for each replica you specify...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2014 at 6:13 am
hendrik.wentzel (4/9/2014)
We have a 5TB SQL2005 SP1 Enterprise edition database running on end of life hardware that we need to move to new hardware.
Please see brief details below:
-...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2014 at 3:50 pm
Native encryption is only available in SQL Server 2014 onwards, as such there are no encryption details stored in
msdb..backupmediaset
msdb..backupset
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2014 at 3:41 pm
Jampandu (4/8/2014)
So read-only replica is always sync with primary and we can query on read-only replica at any time.
Provided the AlwaysOn replicas are configured for synchronous commit, they'll be in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2014 at 3:08 pm
Jake Shelton (4/10/2014)
if memory serves, without the 2K5 step, the hashing will fail as it has changed base algorithm between 2000 and 2005.
Step not required. The algorithm between 2008 and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2014 at 1:32 pm
Jake Shelton (4/10/2014)
My question is whether I need to move the logins to a 2k5 box as an interim step before relocating again to 2008.
No you don't and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2014 at 6:14 am
defyant_2004 (4/8/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 3:01 pm
Viewing 15 posts - 3,361 through 3,375 (of 9,241 total)