Viewing 15 posts - 4,156 through 4,170 (of 9,253 total)
Use the appropriate escape macro, if you dont need to escape any quote marks then the following will apply
INSERT INTO dbo.[DB Mirroring State Changes] (
...
April 27, 2013 at 12:19 am
You could check the history tables see if they have recent events logged
April 26, 2013 at 10:44 am
mJai (4/26/2013)
Anything else?
Yes enable service broker on the database, it's detailed in books online.
April 26, 2013 at 1:03 am
You had service broker enabled before, you'll need to re enable it again. Ideally you should restoring your current backups of your system databases to retrieve the previous configuration.
April 25, 2013 at 9:15 pm
Firstly I would start with the ESX hosts, check the HBA types and settings
April 25, 2013 at 8:58 am
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...
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...
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...
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,...
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
April 24, 2013 at 1:15 am
You'll need to break the mirror session and restore the mirror database with recovery.
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.
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
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?
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?
April 23, 2013 at 10:19 am
Viewing 15 posts - 4,156 through 4,170 (of 9,253 total)