Viewing 15 posts - 4,156 through 4,170 (of 9,244 total)
sql-lover (4/24/2013)
It has been very difficult to explain and support my arguments though. I've been questioned a lot (knowing this by experience) and it is really FRUSTRATING! 🙁
point them to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 2:41 pm
sql-lover (4/24/2013)
The MCS policy was set to "round robin".
You use either MPIO or MCS not both, so, are you using MCS or MPIO?
MCS is specific to the Microsoft iSCSI Initiator...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 2:21 pm
sql-lover (4/23/2013)
Hi Perry,The shared storage is a Dell Compellent SC8000 SAN, connected via iSCSI / MPIO to both nodes. The Windows Cluster runs on Win2008R2 SP1. MS-SQL runs SQL2012 Standard.
I'm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 10:47 am
C:\Windows\system32>net start mssqlserver /f /m /t3608
The SQL Server (MSSQLSERVER) service is starting..
The SQL Server (MSSQLSERVER) service was started successfully.
Firstly don't start sql server as a service, also -f implies -m,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 9:01 am
You should at least understand the basics of TCP\IP networks, these are just some of the items you should have a basic understanding of IMHO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 1:15 am
You'll need to break the mirror session and restore the mirror database with recovery.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 12:03 am
Do you have another backup of model you can use?
If not grab a copy of model from another server with the same collation and version.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 12:00 am
Also, remember that a full backup will reset the page differential bitmaps and increment the Differential base LSN too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2013 at 10:32 am
are you using iSCSI attached storage and MPIO?
Can you provide a little more info on the storage and the connectivity from the nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2013 at 10:21 am
Can you provide a little more info on the storage itself and the connectivity to the storage from each node?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2013 at 10:19 am
rcheneyjr (4/17/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 3:02 pm
You will likely need changes to your network infrastructure and shared storage infrastructure but you should be able to relocate the once you have the above sorted
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 10:19 am
Whatever you use whether it be
Remember that server level objects such as logins, agent jobs, etc, etc need to be replicated...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 1:16 am
This thread is nearly 2 years old!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 12:32 am
A schema is used to collectively identify set objects, the schema can also be used to control permission lists defining access to the collective objects. Users create objects under schemas...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 12:06 am
Viewing 15 posts - 4,156 through 4,170 (of 9,244 total)