|
|
-
|
|
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder ?
What is this all about, Curious? Then here is the answer -
When the transaction log backup files are copied from the primary server ...
|
|
-
|
|
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all the time when I detached a database earlier the feeling was like something which I mentioned before ...
|
|
-
|
|
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common one. In most of cases the default value is not changed.
This configuration specifies the maximum size of data that can be added to a repli...
|
|
-
|
|
Automatic Page Repair is one feature which is not really famous, however pretty much known to most of us.
I wanted to write about Automatic Page Repair since a very long time. Today I decided to test this feature when I had to deploy and do some test cases...
|
|
-
|
|
Today I came across an error for the Distribution clean up: distribution job in one of the environments
Message -
Executed as user: Domain\Sqlagentaccount. Could not remove directory ‘\\MachineName\ReplData\unc\MachineName_Replica_Replica10_PUB\2012...
|
|
-
|
|
Just 2 days back I wrote a post of TUF files related to log shipping. You can read the post here
Today we will see what is going to happen if someone deleted the TUF file accidentally or by any chance it got missed.
I tried to simulate this on my test ...
|
|
-
|
|
I have seen various questions related to TUF files,and one of the discussion was interesting and it was something like below-
John - I don’t understand why we need this TUF file in SQL Server, what does it do? I have been looking around for more infor...
|
|