Thanks for the vote.

How would that be possible? Do you mean failover first then add? The mirror is inaccessible to modify while it's running at the secondary DB......

Sorry about that- I overlooked the 10-15 databases you mentioned up top. Yeah, you are correct that mirroring that many might pose a problem depending on load. However,...

Good idea, I submitted feedback over at this URL:

http://www.attunity.com/request_information

Cheers,

Steve

I suppose you could pick and choose where to place the secondary file on the mirror database.

In my case, I mapped the .NDF to the E: partition, but I had...

With supporting over 200 instances, we implemented an SSIS packages that connects to all instances each morning to determine the last time the DBs were backed up using the same...

haven't seen that before- i would try to uninstall the client tools and reinstall.

I would say that is correct. the delay should set the restore off at 8:30 with a 30 minute delay and it scheduled at 8AM.

The logic needs to be

On...

done, added comment as well.

This script should get you started by telling you the object name, type, and which filegroup its a part of. The rest of the joins can be made accordingly...

I have had this happen where I connect to a new session on my next login to the server. Check Terminal Services Manager and see ifyour old session is...

The typical solution we use at my company is the following:

1. Active/Passive Primary instance.

2. Standalone secondary instance for DR (can certainly be clustered, but we only expect it to be...

If you try creating a new database with an initial mdf size of 512MB in the same C:\Program Files\Microsoft SQL Server\MSSQL\Data\ path, does that succeed?

From your output, it looks...

Thanks Steve. That makes sense based on my config.

Clustered active/passive (Primary) -- all SAN

G:

H:

I:

J:

K:

L:

M: MDF (per initial DB creation)

N: NDF -- added per my initial post.

Standalone (Mirror) -- All...

Can you elaborate on the audit logs you are referring to?

Unfortunately, as Jack said, it's best to take the approach of limiting access.

Having said that, the approach that I would take is to draft up a formal document noting the...