I was able to figure it out.
Here is my solution. I welcome your comments.
Prerequistes: Mirroring Endpoints, 3/4 servers (primary/mirror/logship/Logship backup servers), SQL Server 2005
1. create a backup of the database to be mirrored logshipped
2. copy backup to both mirror server and log ship server
3. recover backup fully on mirror server
4. set up log shipping on the mirror server (initially...
epikto
Last Activity: Jan 25 '08, 07:38 AM
Joined: Apr 18 '07
Location: Carlsbad, CA
-
MS SQL 2005: DB Mirroring and Log Shipping
I am setting up a HA solution which incorporates both the DB Mirroring and Log Shipping with SQL Server 2005.
However I am running into a bit of a snag in configuring the mirror as the primary/inactive log shipped database.
From what I can tell one should be able to configure the mirror DB separately as a logged shipped database and when a mirror failover event happens the Log Shipping jobs should be able to come from... -
Thank you for your reply.
In the original version both console and service a timer was firing the directory search and handling the processing. I just didn't think that detail was important to add to the information provided.
However you were correct in your original assessment. I went through it again and checked my paths and user account logins and all seemed to be correct until I thought that I would change the...Leave a comment:
-
As I feared the UNC path direction didn't work.
Any other ideas? I think the key here is the fact that from the main method it works fine versus not when it is called via an class internal call.Leave a comment:
-
Thas a very good suggestion. I will check the path to see if just using the UNC path will work. It hasn't previously but that was many cycles ago.
However how does that explain the console app which experiences the same problem under the same conditions? I don't believe that it would run as a local system account since it is started by the user.
Finally as regards to NTFS permissions I have made sure that this share...Leave a comment:
-
C# - APP: Troubles Getting a directory Listing of a Mapped Drive
I have a mapped share that I am trying to get a listing of all the files that it contains.
I use the following code to access the contents
String[] files = Directory.GetFi les(path);
I can then enumerate through that array to get my listing.
However I am trying to set my application up as a service. And now (after calling methods in a thread using the OnStart() method) it says the directory does...
No activity results to display
Leave a comment: