There wont be any issues. Just use MOVE command on your restore script for an alternate location for db files.

Thanks Gail/Perry.

Thanks Gail.

I was thinking if it's a best practice not to allow the file to grow too much and I can split across separate drives/spindles. This particular db is almost...

Server 2012 R2.

In our scenario, SQL is clustered(2 node) and we don't want windows cluster to be down even if the replica server- 3rd node (reporting) goes down.

Thanks Perry.

*Can you provide a little more detail on the encryption implementation

Column level encryption is enabled for one of the tables in this database (Symmetric key protected by a...

Thanks.

What is using upto 26 GB on top of max memory (215gb) pre-allocated to this instance? It's increasing by almost 1gb per week where it was 25gb last week.

Perfmon counters:

Total...

Database Documentation listing the objects in the database and their relations.

Thanks Perry.

Does the REDO blocking occurs even if there is only one secondary replica which is configured for asynchronous commit?

I've formatted all drives with 64k (data drive/log drive/system db drive/ tempdb drive/ sql installation drive)

Also the stripe size is 128K set at RAID controller level.

OK thank you.

Removed the dbs from AG. Will add the dbs to the AG once the DR is available.

One secondary, which is setup for DR. Thanks.

http://sqlity.net/en/2460/sql-password-hash/

This article says sha1 from sql2000 and sha_512 from sql 2012.

Is it SHA1 hashed algorithm used by default for sql user password, in sql 2005?

Thanks Perry!