The DB doesn't have to be in single user mode, but there must be no connections using that database, sleeping or otherwise.

You get inden fragmentation from shrinking the data file. If you repeatedly shrink and grow the log though, you'll get fragmentation within the log.

The transaction log consists of a number...

Are the log backups succeeding?

Maintenance plan of custom job?

What's the pattern of log growth? Is it stable in size during the day and growing at night? Is it constantly growing?

If...

YSLGuru (9/22/2008)

---

2) Are there features and or changes in T-SQL as of SQL 2005 that are not applicable to use against a database on SQL 2005 with a compatability level...

Full, diff or log backups?

Do you have any DB maintenance happening after 9pm (index rebuilds)?

What's the pattern of log...

What do the following two counters look like?

Physical disk: Avg sec/read

Physical disk: Avg sec/write

You can use profiler to see all the queries run against a server.

To check:

What recovery model is the DB in?

Do you have log backups running (not applicable if the above...

Duplicate post. No replies to this thread please. Replies to

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

No.

Databases cannot be downgraded in version (2008 to 2005, 2005 to 2000)

To get a SQL 2005 DB to SQL 2000 you'll have to script out the schema, bcp out the...

GSquared (9/22/2008)

---

Once you switch to 90, you can't switch back to 80, except by restoring from a backup taken before the switch. (Which means, of course, that you'd lose...

webrunner (9/22/2008)

---

I have a SQL 2000 database on a SQL 2005 server (still in 80 compatibility mode), and it seems that some standard reports (Index Physical Stats, etc.) don't run....

Depends how often it's used, how expensive it was to compile, how much memory pressure the server's under and a whole bunch of other stuff. The table's not a list...

The book suggestion was for bhuvnesh, since he asked about certification notes.

I don't live in...

The self-paced training kits from...

No, just the last diff, then the log backups from that diff up until the point of the dropped table.

Differential backups are cumulative from the last full backup.