Reputation
485
Top tag
Next privilege 500 Rep.
Access review queues
Badges
4 15
Newest
 Informed
Impact
~21k people reached

  • 0 posts edited
  • 0 helpful flags
  • 22 votes cast
Jul
27
comment SQL Server Mirroring Removed
I have just started and stopped the end points and it looks to have sprung back into life. My question now is what can cause the end point to mess up like this?
Jul
27
comment SQL Server Mirroring Removed
2012 - I know but we had too
Jul
27
comment SQL Server Mirroring Removed
The databases are all In Recovery so looks like it as removed I believe
Jul
27
asked SQL Server Mirroring Removed
Jun
25
awarded  Informed
Jun
25
asked Replay Trace Results Slower On Better Server
Jun
23
revised Compare Traces with RML Utilities
added 58 characters in body
Jun
23
asked Compare Traces with RML Utilities
Jun
13
awarded  Inquisitive
Jun
12
comment Create Database and LCK_M_S
Have added the code
Jun
12
revised Create Database and LCK_M_S
added 2308 characters in body
Jun
12
revised Create Database and LCK_M_S
added 97 characters in body
Jun
12
asked Create Database and LCK_M_S
Jun
11
comment Attaching Database Incorrect name in sys.master_files
I don't follow, let me explain again. In sys.master_files on my source server the name of the files might be Tom1.mdf and Tom1.ldf. When I move them to my new server it would get renamed to Tom1.mdf and Aaron.ldf. Now this would happen for every database so in sys.master_files I would see lots of different mdf names, but the same ldf name for every database. As a side note if I looked at the logical names in the GUI then it would look the same as it was on the source server. Are you saying this is expected behaviour?
Jun
10
comment Attaching Database Incorrect name in sys.master_files
Interestingly when using the ALTER DATABASE command you have to put in the name of the file you want the name to be in both the NAME and NEWNAME fields. This feels like a bug to me. Further to that the names are correct on the source server so it must be picking up this other name from somewhere just I don't know where.
Jun
10
accepted Attaching Database Incorrect name in sys.master_files
Jun
9
comment Disk I/O and PAGEIOLATCH_XX
hmm that actually produces a different result set.
Jun
9
comment Disk I/O and PAGEIOLATCH_XX
I have updated the thread with more information
Jun
9
revised Disk I/O and PAGEIOLATCH_XX
Updated with more information and problem procedure
Jun
5
comment Disk I/O and PAGEIOLATCH_XX
Yes but with all latency looking like its within acceptable parameters could this still be a disk issue, perhaps a SAN fabric problem. Would it makes sense to make that conclusion?