Viewing 15 posts - 4,831 through 4,845 (of 9,244 total)
pwillemsen (10/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 1:17 am
ankur_libra (10/9/2012)
SQL Server 2008 Std Edn 64 bit on both servers
Database X State at Secondary Server (B): Restoring
Problem:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 1:16 am
You don't need any downtime for the full and log backup\restore from the principal to initialise the mirror.
Terence Keys (10/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 1:14 am
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
Viewing 15 posts - 4,831 through 4,845 (of 9,244 total)