Attempting to re-start using SQL Server Configuration Manager but taking a very long time. Can I just kill the sqlservr.exe from task manager and start the service via SQL Server...

Can't even use DAC. I get a timeout error message!

Time to re-start the SQL Server instance?

There's 8GB memory. The SQL Server instance is configured to use the max (it still has the default value). But is task manager accurate enough about memory usage? It doesn't...

You say the windows user is created but have you created a SQL Server login as well?

capnhector (11/13/2012)

---

Nice DDL Trigger on the create database however you can avoid the cross join to sys.databases by using the following query:

Makes no difference in the long run im just...

Forgot to mention that I also have another trigger for when a database is removed:

CREATE TRIGGER [DDLTriggerRemoveDatabaseBackupSchedule]

ON ALL SERVER

FOR DROP_DATABASE

AS

declare...

Ah but in my...

Thanks for the confirmation.

Rrrrright.. so because backups are online, SQL Server will include some transactions with the backup file so that when the DB is restored, it is in the state as it...

Okay... I've shrunk the LDF file so now I hope that 36Gb has been given back to the OS.

I've also set the LDF to initial size 50MB. I'm not really...

HowardW (11/13/2012)

---

Assuming that the growth to 36GB was an unusual activity or was caused when it was in FULL Recovery Model and TLog backups weren't being run, then yes, a...

Anyone care to comment about my solution of creating a schedule table to control the backups on a SQL instance?

Is this a bad idea?

Very good! I have much to learn.... 😛

I'm glad you asked about what I'm doing.

Let me try to explain, I have:

1 SQL Server Instance with 25 databases (I actually have...

As Steve suggested, you need to enable further logging.

I had an issue with a SQL job the other week and I wasn't getting enough information so I followed the advice...

Yup... I did entertain this idea of custom logging before but I thought I'd check with you guys in case I'm duplicating unnecessary metadata. But it does make sense and...