Thanks Guys

I think your right.... sometimes it just takes a fresh pair of eyes to spot what is staring you in the face

:w00t:

Many thanks, You are a star.

I can't believe it was that easy a fix.

Taggs

Hi Anthony,

Thanks for the advice, I will setup another schedule for that time and setup a trace.

Hi Grant,

Thank you also for your advice...as it is only a monitor we are...

I'm not 100% sure but I'm pretty sure it is creating statistics. I'm sorry I can't be more specific..

Thanks

Ploblem solved? I'm not sure!!!

I've tested my script a couple of times now and it has worked OK. I've added a few sleeps into the script and that seems...

Yes, creating the security will come next.

My plan is

Create AD groups

Created DB's

Create users

Set security

Created secuirty scripts

Created DB clone scipts (ie live -> Test etc)

Email Backup guys (we use Networker...

The plot thickens.

For a test, I thought I would remove the loop and add all three servers in manually (one at a time) to see if this works. Now...

Thank you for looking. Yes, all three servers are in mixed Authentication mode.

Thanks

Taggs

OK, thank you for taking the time to reply.

Taggs

REVOKE VIEW ANY DATABASE FROM user

I use

REVOKE VIEW ANY DATABASE FROM public to restrict all users seeing the databases in SSMS

Taggs

Very similar Code but this is what I have done in the past.

It may help 🙂

Declare @date varchar(10),@BulkCSVImport varchar(200)

set @date = convert(varchar(10),getdate(),105)

set @BulkCSVImport = 'BULK Insert HDD_Info_temp from...

The SQL Server Config manager is an MMC snap-in. It can usually be located in start > All Programs > MS SQL server 2005 > Configuration tools.

Expand SQL server...

Put code simlar to the followind in a SQL agent job and set the job schedule to the required time. The user running the SQL agent must have the correct...

Many thanks. It all makes sense now.

It's not the full backup that makes the log reusable, it's the log backups.

Thank you for imparting your wisdom

Taggs

🙂

Hmm, I'm a little confused. Although the file still has the data (which I thought it had cleared) that portion is now reusable?

The article says the following

If a log backup...