Viewing 15 posts - 4,831 through 4,845 (of 9,241 total)
Thanks, if you found the article helpful please don't forget to rate it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 1:10 am
darrenstokes (10/9/2012)
With mirroring I wont have any outage when the above quite likely scenarios occur.
Depends on the mirroring mode you are using.
In any mode other than High Safety with auto...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 7:29 am
Ratheesh.K.Nair (10/9/2012)
Hi Experts,I know we have to run a full backup if we change the recovery model from full--> simple-->full.
No, you can just run a differential to restart the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 5:42 am
to add to Gail, in fact in some cases if you have a large number of files per filegroup the file switching can be a performance issue. SQL Server attempts...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 5:38 am
I have, in the past restored a master database to anohter instance as a user database, then detached it and renamed the disk files to their original names and then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 5:31 am
Network DTC access needs to be enabled, was it working\enabled before?
Without knowing a lot more about the system and access to the logs it's very difficult to say. MSDTC is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 5:10 am
darrenstokes (10/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 5:06 am
As i said MSDTC is the OS level so troubleshoot there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 4:53 am
either\or not both
Lookup DBCC SHRINKDATABASE and DBCC SHRINKFILE. You'll see this a million times on here, why do you want to shrink the database or its files?
They'll likely only grow...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 2:45 am
mah_j (10/9/2012)
the servers are in a workgroup.
To use Log Shipping in a workgroup see my article at this link[/url] 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 2:36 am
arr.nagaraj (10/8/2012)
What can be the possible causes for MSDTC Autofailover?
Could be anything, this is outside of SQL Server, have you checked the event logs and cluster logs for more detail?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 2:31 am
are the servers in different domains or a workgroup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 1:41 am
mah_j (10/9/2012)
yes exactly as you said.
So how can you state that the servers "cant see" each other.
The access you are describing requires Netbios ports to be opened!!!
If you can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 1:19 am
SQLSACT (10/8/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2012 at 12:02 am
mah_j (10/8/2012)
i use map network to see the drive on server A to have the backup files
The way i am understanding what you have said above is that on server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2012 at 11:58 pm
Viewing 15 posts - 4,831 through 4,845 (of 9,241 total)