Well, the more I've been thinking about it, the more I'm leaning to having one database with everything under it.

I may lean towards utilizing a schema per program since each...

That's what I was thought.

I'm moving stuff over from Access to SQL and I'm cleaning things up. One of those things is converting that stuff to keys (which I've...

For the most part, I have had success with the SSMA. Since my DB is rather small, SSMA takes no time at all.

The only thing that I'm still researching...

Not too long before your post, I did try it with the overwrite option and that did the trick.

I cleared out all the logs and everything picked right back up.

I...

I get this message when trying to do a full restore on my secondary

Restore failed for Server 'TestServer2'. (Microsoft.SqlServer.Smo)

------------------------------

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The tail of the log for the database "ET"...

I did a test where I brought online the secondary server and had my app connect to it, so that was successful (good news there).

I set everything back to normal...

So far so good.

I had a dns alias put up and pointed it to the main server.

I stopped the primary's services and brought up a test secondary that was getting...

Thanks for the info, I changed those services like you said and also did this:

For the secondary db, I did a restore on that one manually and got that up....

Does it sound like I'm understanding the procedure correctly otherwise?

Do both folders on each machine need to be shared? For example, does the primary not only back...

I couldn't find a free MS Virtual Server...do you have the link?

As far as DNS Aliasing goes, is that something that is setup within the application or is the alising...

So, I did a practice restore on another server and now I have a question.

In the real world, if I did lose the server, would it be best to name...

Ok. I did do a restore of just the db itself and that worked.

I haven't tried it restoring the other system databases though.

I suppose I could try to acquistion...

I would like to simulate hardware failure.

Yes, I have only 1 database server and it's dev. Funds to purchase a production server should free up hopefully in the next...

They appear to be local copies of the tables. But for what purpose I'm not sure other than to just "have them".:ermm:

Can someone shed some light on what these are:

I see the linked tables in the access program, which is what I expected.

I also see these tables for it looks like...