Would [WITH ROLLBACK IMMEDIATE] help?

Andrew

Hi,

If you're trying to avoid log growth you could pre-size the transaction log to avoid auto-growth operations.

Andrew

Hello,

There's good information on indexes on the MSDN website. Should give you the required background information:-

http://msdn.microsoft.com/en-us/library/ms189271(v=sql.105).aspx

Regards,

Andrew

I'm not too familiar with stunnel but you could check your logins on the instance. Does the specified login have the required permissions?

Andrew

One really good powershell script is one a colleague sent me that emails me total disk space and free disk space for all servers listed in a text file:-

Have a...

You could use a CNAME alias in DNS to map to either your Dev or Live server.

That way, when you wish to change the connection, you change the alias and...

No worries no this.

All I did was open the DMK and then regenerate using the original password.

I'm able to decrypt the data now.

Andrew

Hello,

The maintenance plan was created in SSMS. The instance on the server is definitely SQL Server 2005 Standard SP4.

Bit of a weird problem I admit, cannot find out why this...

Thanks Guys, I'm currently trialling RedGate, Idera and LiteSpeed. Think we will probably go with Idera.

Andrew

In the meantime does anyone have a script that will generate CREATE STATISTICS statements in a DB?

Thank you,

Andrew

The log is still showing that SQL is still restoring indexes to the new collation. I'll check again tomorrow but hopefully this will work!

Andrew

Definitely, the database has been migrated to a test environment and the startup parameter implemented.

The problem with the Stats was that there are user created stats in the database which...

Brilliant. I think it was just me being impatient. I can see in the log that the indexes in my DB are currently being restored.

Thank you very much!

Andrew

Thank you, does this work for SQL Server 2005?

Regards,

Andrew

Thanks Pratiksha,

Does the software support compression and encryption of backups?

Regards,

Andrew