Viewing 15 posts - 1 through 15 (of 39 total)
Seems a good idea. Feel free to add it to your implementation.
March 7, 2013 at 8:55 am
Agreed. At the time I wanted this capability there was no comprehensive script available. This capability should be SSMS already since it was in Enterprise Manager for SQL 2000. Amazing...
December 8, 2011 at 4:01 am
There is a free GUI tool you can get from Idera for doing this too. We use it at my site all the time. It is very good. I don't...
December 7, 2011 at 5:56 am
yes this article is about copying backup files but you can copy mdf and ldf from one server to another and then attach them.
November 11, 2011 at 10:22 am
Yes the copy will work OK so long as server1 and server2 are both not using the mdf and ldf files whilst they are copying over.
Note that mdf and...
November 10, 2011 at 6:58 am
Or this obvious bug should be fixed! 😛
November 7, 2011 at 4:53 pm
You can get eseutil from the web if you look via google "eseutil download". It's installed with MS Exchange but all you need is 2 files eseutil.exe and eseutil.dll and...
November 7, 2011 at 2:39 pm
Be aware that using the /z switch (restartable mode) for Robocopy slows it down massively cant tell you how much but something like half speed. You are better off not...
November 7, 2011 at 4:58 am
If you need to remove TDE you need to also do what it says here:
November 3, 2011 at 4:56 am
Thanks for this Steve - I've added a link back to this in my article "TDE Setup and Administration Scripts"
November 3, 2011 at 4:55 am
create trigger ServerAuditTrigger
on all server
-- Audit server level and database level into dbadata.dbo.ServerAudit
-- The database level is also audited into <database>.dbo.DatabaseAudit
with execute as ''server_audit''for ddl_events
September 28, 2011 at 3:39 am
I have not encountered this problem and do not want to set out to cause it either! It is probably a SQL Server bug.
I see that there is some evidence...
April 6, 2011 at 3:54 pm
This might help you:
It does explain how you can have a different master key on different servers. In my case I do not need to do this and...
April 4, 2011 at 4:56 pm
Shortly there will be 2 extra scripts and an associated update to the documentation. These scripts are for uninstalling and re-installing DDL audit capability for one database only. The scripts...
April 4, 2011 at 4:33 pm
Why did you create a new master key on instance2? :w00t: This is probably the cause of the problem.
The correct sequence to restore an encrypted database from one instance...
March 18, 2011 at 5:45 pm