Check out this thread:

http://www.sqlservercentral.com/Forums/Topic478154-24-1.aspx

This gives the backups and the sizes. Looks like it's what you need.

Look in the msdb.dbo.backupset table.

Hi Ola.

For each transaction into SQL Server 2005, my (admittedly naive) understanding of the process is that SQL will:

1. pull pages that needs to be modified into the buffer cache

2....

This is an auditing database so it has to run 24x7 with a low exposure to work loss.

Hmm... I think your test is good but tough to prove out...

I thought that was true for SQL Server 2000 but not 2005?

Check out this table:

http://msdn.microsoft.com/en-us/library/ms189315.aspx

From this I gather that the two run concurrently. I could be misunderstanding this though.

The...

I'm not sure I understand your request entirely. Are you looking for a script to create the TSQL commands for you to use elsewhere or are you looking for a...

Networking group confirmed there was some switch maintenance happening during those times.

Still... some of those messages from SQL are a bit alarming.

Ironically, I found this doing QotD and it answers some of my questions:

http://msdn.microsoft.com/en-us/library/ms189315.aspx

Also, after you delete (or add) files: MAKE SURE you take a full backup of the db before you take any tran log or differential backups:

http://msdn.microsoft.com/en-us/library/aa933089(SQL.80).aspx

I had to move tempdb files last week. I don't remember the exact error but I couldn't get SQL to start. Finally I figured out that the right service didn't...

Agree...

I'd take the shrink out of the plans. Unless you purge a lot of data out of those DBs, shrinking will do more harm than good. SQL will grow files...

Figured out the problem.

Changed:

@wrkStatement = @curr_db + '.dbo.sp_executesql'

To:

@wrkStatement = '['+@curr_db + '].dbo.sp_executesql'

- AND -

Changed:

FROM ' + @curr_db + '.dbo.sysfiles a'

To:

FROM [' + @curr_db + '].dbo.sysfiles a'

The [] around the...

Definitely. I tested it on several servers. It works on most. On one it gives me the linked server error. On another it gives me this:

Msg 102, Level 15, State...