Why are you not using msdb database. It will have all your backup information stored in the system tables.

select * from backupfile

select * from backupset

Check out these tables.

Same status for the last 24 hours. I assume this is not a production server.

You will have more information on the sqlserver error log and the event viewer.

Please...

Is there a way to shrink the tempdb without having the downtime?

Thank you for the easy question. 🙂

GilaMonster (3/13/2012)

From Books Online:

Gail,

I am interested in this point. I have no valid reason why database doesn't take variables.

Do you know...

There are a lot of ways to do it.

I would rather pass the two rows as a string and split the strings inside the calling SP.

Jeff Moden has...

Hi Guras,

May be the SQL error log can help you to explain you on the part of the db shrink.

Check with application team any new deployment that deletes...

Nice straight forward question.

Hi Guras,

Did you manage to figure out what is the issue.

if not, can you please share the scritps that you use to log the db size and if...

Do you have any index rebuild jobs enabled between the time period where the shrink of file actually happened. I have a feeling that your tables might be fragemented and...

Hi Bitbucket,

The link you provide is not correct.

http://www.sqlservercentral.com/questions/UNION/88678/http://www.sqlservercentral.com/Forums/Topic1205649-1222-2.aspx

And there is a typo in the question.

SELECT Id,,ProductionDate FROM Foobar

Initially I was confused whether it has to...

Nice 🙂

Thank you for the simple question. + 1 added.

You probably need to read this.

http://www.sqlservercentral.com/Forums/Topic440435-5-1.aspx

--- Babu

I did not knew this. In the end, I guessed. +1.

Nice to knew this table. As we do so much on alerting.

Thank you.