Shrink all user database files

Shrink all user database files

Dynamic Transaction Log Backup

Backup up all transaction logs based on sys.databases.

T-Log Backup/Restore with Date & Time

Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.

SQL or MDX query trace in SSRS - trick of imagination or a real thing?

I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...

Automated T-Log Restore

Sequential transaction log restore

System database logging recovery models

usp_ShrinkDBLogs

A T-SQL script to truncate your user database logs.

RE: Performance Tips Part 1

You can rename indexes and other objects:use pubsif object_ID('test_rename_HIS') is not null drop table test_rename_HIS if object_ID('test_rename_ARC') is not null drop table test_rename_ARCcreate table test_rename_HIS   (ID int Not Null constraint PK_HIS Primary Key,    Name varchar(255))go create index I_HIS on test_rename_HIS (Name)go exec sp_rename  @objname =  'test_rename_HIS' ,     @newname =  'test_rename_ARC'  ,     @objtype […]

RE: Cant drop user - Help!!

It is because this user does not exist in this server. First of all the user must have a login that exists. You can create one if you are a sysadmin. Then you have to associate the login with the database user, because at this point it is an orphan and SQL Server does not […]

RE: The process could not enumerate changes at the Publisher

Hi Chrisitian, as I know in 99% the 'General network error' is really a network error. So I guess you have to check your underlying network configuration. However I noticed that if the server is under heavy load (too many replications at once, or bad configured indexes causing table scans) this error also occurs. Try […]