Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

Some other connection might have the database open in single user mode.

You would have to kill that connection before the database can be set offline.

This is really an age old problem with no true solution. People have to be trusted with access to various valuable things, and there are always those that will...

I was a manager at a company that was about to have a layoff. Several managers at my peer level were sent an email that had been put together...

You can check yourself to see if backups were run. All backups are recorded in the msdb database.

This query will get you started:

select

a.name,

bs.*,

bmf.*

from

master.dbo.sysdatabases a

left outer join

msdb.dbo.backupset as bs (nolock)

on...

jim.powers (8/12/2008)

---

Michael Valentine Jones (8/12/2008)

---

Sometimes it is necessary to have different servers because they have different maintenance windows for the applications.

One might have a downtime window of 0100-0600 on Saturday...

Sometimes it is necessary to have different servers because they have different maintenance windows for the applications.

One might have a downtime window of 0100-0600 on Saturday and Sunday, and the...

Abhijit More (8/8/2008)

---

I would say that change the recovery model to SIMPLE, before that take a full backup of your database and as Mike said decrease the time limit for...

helloanam (8/7/2008)

---

I think first and last date of year will always be same irrespective of what year is it. 😉

first date: 01/01/ year

last date: 31/12/ year

therefore, no need to use...

You need to have transaction log backups often to control the size of the transaction log, expecially if you are doing large batch operations, like reindexing, index defrag, or big...

select

a.MyYear,

FirstDayofYear= dateadd(year,(a.MyYear-1900),0),

LastDayofYear= dateadd(year,(a.MyYear-1899),-1)

from

(

-- Test Data

Select MyYear = 2001union all

Select MyYear = 2002union all

Select MyYear = 2003union all

Select MyYear = 2004union all

Select MyYear = 2005

) a

Results:

MyYear FirstDayofYear ...

You should run transaction log backups a lot more often.

I usually set them up to run every 15 minutes, but run them as often as every 5 minutes if there...

I ignore all private messages. Not that I get many.

It might be good to have a setting to allow you to turn off private messages, so that people don't...

Jeff Moden (8/5/2008)

---

Michael Valentine Jones (8/5/2008)

---

I believe there is still a limit of 256 tables in a query (haven't verified that, so I could be wrong), so if you have...

Jeff Moden (8/1/2008)

---

With the advent of VARCHAR(MAX), there's just no need for cursors anymore... for example...

DECLARE @sql VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL+CHAR(10)+' UNION ALL --------------------'+CHAR(10),'')

+REPLACE(

' SELECT ''...