If the backup files are stored on the source server; you'll need to open port 135 I believe so you can access the UNC path on the source server.

I believe...

Mohit.

Look up CAST and COVERT functions in books online :).

Mohit.

Do you have backup for you master database?

I would rebuild the database and restore it from backup to get in operations. Copying master database from another instance is not best...

I prefer mirroring because of automatic failover ...

Microsoft article on setting up Mirroring with sharepoint:

http://technet.microsoft.com/en-us/library/cc262910.aspx

There is no tool to repair Access DB file but what is the issue you are running into?

The normal repair that I have used and been successful with is create...

Few things come to mind ...

1) Express edition does not allow remote connections by default; you must enable it.

2) If you already have an instance running on serer your second...

You can do that but I wouldn't recommend it; because in a 3-partner (Principal-Mirror-Witness) configuration; if two partners go down then the remaining partner database become inaccessible.

So in this case...

Hi Simon,

How is your network configured? Where is the web server and where is the SQL Server? Are they on the same subnet? Ideal recommendation ...

- Have...

Heh Thanks Lynn. I have never rolled backed as I said I have uninstall / reinstall. Making sure to have my System DB backups so I was able...

It can affect the system dbs because resource db is updated when patches are applied; because if resource db fells out of sync from the sql version we can have...

How I normally do it is, I verify no security issues exist that will affect my environment. From there I only patch SQL server twice per year, unless of...

1. To get the email address from a table just do a DECLARE and SELECT statement to pull the information like you did to see if the email needs to...

Few things to check if automatic failover is not taking place:

1) Both servers can see witness.

2) Your mirroring is set to automatic failover.

SELECT *

FROM sys.database_mirroring

Columns of interest: mirroring_witness_state_desc,...

lwolfe (4/1/2009)

---

select count(*) from sys.server_principals

69

select count(*) from [Database_Name].sys.database_principals

33

select *

from master.sys.server_principals

where sid in (select sid from [Database_Name].sys.database_principals)

15

select *

from master.sys.server_principals

where sid in (select sid from [Database_Name].sys.database_principals)

0...

Cheers :). Sorry didn't get back to you, have fun with Mirroring. I absolutely love Mirroring :blush:.