stevefromOz,

thanks for the references.

The data is growing all the time, it is possible it went over a threshold. The appearance of those .axis files on the same night the process...

Ells,

thanks for your reply.

I had already extracted the DTS log out of the msdb database. A number of cubes are processed and each one is showing an increase. The increase...

Ray Mond (9/23/2011)

---

Perhaps you could try copying a large file to the same network share, and observe if the same behaviour is exhibited. If it is, then it is...

Grant Fritchey (9/20/2011)

---

Network backups are notorious for poor performance, although this precise behavior is not one I've seen. Generally, you're better off backing up to attached storage and then copying...

The utilisation drop is gradual eg starts at 25%...

I think I have found my own answer to this one. The clients in question are going to use the net library they are intended to use. There is no...

Our rule of thumb is:

1. Never overwrite an existing backup file.

2. Always have at least 2 separate, usable backup files on availiable media.

The first was to handle the situation where...

Erik,

thanks for the info.

Another question - does the VSS writer pause all the SQL Server database file writes on the volume being shadowed, or does it pause ALL writes from...

Alter database cannot be done on tempdev2 and tempdev3 - it says they do not exist.

The entries do exist in sysaltfiles. What I suspect is happening is the tempdev2 and...

It turned out to be a missing WITH LOG clause.

There was confusion over where the error was been raised - the calling procedure,...

I am refering to SLS as provided in the Microsoft SQL Server 2000 Resource kit, not MiniSQLBackup or LiteSpeed.

Changing the line

WHILE @StartDateTime < @EndDateTime        to

WHILE @NextBackupDateTime < @EndDateTime

looks...

Thanks. Those ideas and articles made me think about what is going on. It looks like they disallow the changing of the database context using a variable due to the...

I agree about keeping the original scripts to create the database objects. But the 3rd-party vendor who wrote the application does not provide them.

Also, the filegroup defs do not match...

From the responses it sounds like a scripts generated from the database definitions is the way to go. It doesn't sound like there is a 'one-step' process, similar to the...

You will have to convince your Network Administrator that you are following a security policy and that your SQL Server logins are secure. SQL Server has a bad reputation due...