The size of the Publisher DB log file should be about right - thanks.

The plan we're looking at now is...

1) Change the subscriber to Simplle Recovery

2) Full Backup

3) Shrinkfile command.

The Publisher DB already has daily full backups and transaction log backups 4...

If the length of the string might vary - but there will always be brackets - this will work:

declare @string varchar(max)

set @string = '{String you want to remove from the...

I don't remember my logon from then, and I know I no longer use the email address I used at that time (Compuserve). I'll sign on with...

Does Microsoft have a page where you could look up a name and confirm their certifications? Last time I was job hunting, I listed an old certification in...

More information about Robocopy.

If you want to automate this, create a series of jobs that set the DB offline and run the MODIFY FILE command int he first step, call a Robocopy script...

What rights does the user being used have? It should be sa, a user in the sysadmin, or dbcreater role.

Good point. As long as the variable value is not set, the following code resturns the same result whether the word NOT is there or not. Use IS...

Interesting... I've always used "<value> IS NULL" having learned T-SQL from an application I supported. Using the default configuration "<value> = NULL" doesn't genertate an error...

Are their logins set to expire?

In this case, the network share is on the same server as the SQL instance. I use that share to copy items (like BAK files from other SQL...

Thanks. Altough you would think that when logging in remotely as "sa" you should see files in the folder designated as the "Backup" location during installation.

In the interests of...

The easiest way is to have the application write values to modifeddate & modifiedby columns when data is changed. You can also create triggers to do this also,...

Paul Randal writes:

"In 2005, a guy called Paul Randal rewrote DBCC CHECKDB again to use database snapshots to get the consistent view of the database (as a database snapshot...