SELECT name as [Database Name], recovery_model_desc as [Recovery Model]

FROM sys.databases

WHERE name NOT IN ('master','model','tempdb','msdb')

GO

Steve,

all the user tables have is_ms_shipped=0 and all the systemtables generated by sql server have is_ms_shipped=1 but this bit is not always set correctly as far as I know and...

mgrammer (3/20/2009)

---

They do have a type of U and a type_desc of USER_TABLE but is_ms_shipped is marked as 1 and I believe it should be 0. I realize that...

What database backup did...

klnsuddu (3/20/2009)

---

Hi,

After upgrading sql server 2000 to 2005, we should do the following for user databases. Does this applies system databases too OR not? please clarify me

DBCC UPDATEUSAGE

...

and also a snapshot of your errorlog file which includes any specific restore commands.

BlackHawk (3/20/2009)

---

Assuming a system would have log shipping configured and running would any of the following scenarios break the log chain and end the log shipping, or will the transaction...

DonKraft (3/22/2009)

---

Hi

I have a database hosted remote, where I have access in Management Studio etc, but not to the file-system of the server.

I want daily backups or more, but cant...

Amit Lohia (3/19/2009)

---

Steve Jones - Editor (3/19/2009)

---

A CEO must lead the management of the company, and work to drive forward the vision of the entity, and provide an example of...

rbartram (3/19/2009)

---

No matter where you backup to, the key is making sure your Backup software backups and verifies the SQL backup file correctly. The worst thing in the world is...

Lowell (3/18/2009)

---

Keep at it Krishna;

I'd like to see a default Data Manipulation Language (DML) trace automatically running all the time as well as the Data Definition Language(DDL) trace;

just to...

Atul DBA (3/19/2009)

---

The best practice for Backup process is have a Full Backup once a week and then diffrential backup every night and Transaction Log backup every hour based on...

That's the way to go. Proper...

GilaMonster (3/19/2009)

---

I can't take credit. Kimberly Tripp[/url]'s been...

Hi Shnex,

shnex (3/19/2009)

---

so if I make a backup to a log....is it the same as working with a database....I will have to restore it, and only this way I...