Viewing 15 posts - 4,441 through 4,455 (of 9,244 total)
If you have a principal server with database file path "D:\MSSQL\MYDBS" and you create the database file "D:\MSSQL\MYDBS\adventureworks_data2.mdf" and the path does not exist on the mirror, this will cause...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2012 at 7:06 am
SQLCrazyCertified (12/27/2012)
Does anyone know what else can cause the mirroring to be in a suspended state?SueTons.
Creating a new file on the principal when the file paths between the principal and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2012 at 2:24 am
APA0876 (12/20/2012)
because of the following error:
Rule "Existing clustered or cluster-prepared instance" failed
The instance selected for installation is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2012 at 12:05 pm
RVO (12/20/2012)
Apparently we have a big Oops.Out Infrustructure team (Network Admins, Hardware people)
don't know how to configure Cluster environment on Windows 2008 server...
Hmm it is worrying, however, check my...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2012 at 5:15 am
Killing the agent is bit like using a sledge hammer to crack a nut. Just disable the jobs that you don't want to run!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2012 at 10:12 am
Go into programs and features via control panel, select sql server installed software and select change
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2012 at 5:03 am
APA0876 (12/17/2012)
I'm wondering how can I avoid the SQL server Agent to start o SQL Server failover cluster. I changed the start mode to disabled but I haven't checked doing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2012 at 4:58 am
what does disk administrator show?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2012 at 4:21 pm
No, only edition upgrades are supported
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2012 at 4:20 pm
rambis34 (12/17/2012)
all of the active 2008 R1 instances on that node failed.
I'm assuming you mean SQL server 2008, there is no R1.
rambis34 (12/17/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2012 at 4:13 pm
robert.baird 2778 (12/17/2012)
I have a physical 2-node cluster. MSSQL 2008R2(sp1) sitting on Windows 2008R2. We are preparing to migrate off of our existing C7000/EVA architecture and onto...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2012 at 3:57 pm
Multiple named, yes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2012 at 9:08 am
Hemant.R (12/17/2012)
hi ,i m executing DBCC checkdb on weekends for large database , bcoz its taking more time to execute .Need suggestion whether to execute daily..
Try using the PHYSICAL_ONLY clause...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2012 at 1:07 am
Thanks for posting back this may help others in the future.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2012 at 3:52 pm
Attopeu (12/11/2012)
I have two node cluster with non-shared storage setup in my TEST environment in one data center. I successfully setup Availity group with a test database between these two...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2012 at 7:58 am
Viewing 15 posts - 4,441 through 4,455 (of 9,244 total)