Thanks for your response but I'm managing the whole process using sql therefore need the t-sql statement.

Thanks for your help all. I've pretty much nailed it now. Thanks again.

Thanks for the link but it doesn't help me.

The situation I'm in is that I have removed the certificates from server A.

I have the certs on...

(removed)

Thanks Perry - I have removed the cert information. As the certs are encrypted by the database master key, does this mean they will be easily re-created. What...

Can you attach the link please... Thanks

Hi there - Not sure if this is meaningful; (certs removed)

I have a Master database backup which should contain the cert - Any advice on restore the Master db as I'm struggling to put the server into single user mode

the certs exist on another server (which the db orginally came from), is there a way of scripting them out and copying them to the server?

Thanks for this. If I have dropped the certificate, would it be possible to then unencrypt the databases which are still attached to the server?

Thankfully the user...

You should take transaction log backups more often, once you have preformed a transaction log backup you can then execute a shink command on your .ldf file.

If you're inserting data in a table, then more than likely the insert transaction is locking the tables therefore the application is not going to be able to access the...

Hi there - As you're inserting millions of rows into a table, I would strongly recommend dropping the index, inserting the records then re-applying the index once your process in...

Hi John - I was going to allocate 7.2 gig (36 gig / 5 instances) to each database instance as thought this would be the most efficient way to manage...

Thanks for the response guys.

The instances contain the exact same number of databases and almost exactly the same information.

The different database instances are used to test against...