that setting covers just the buffer pool, there is also proc cache, locks, connections.

you need to monitor process:private bytes and working set for the SQL server process.

Remember SQL loves memory,...

http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

why don't you want to use a DDL trigger?

have you set max memory in SQL Server?

I thnk sp_help_revlogin is what you want.

I personally have a sqlagent job that produces the results of sp_help_revlogin which is then xcopied to the DR server.

If you can get the...

pls confirm SQL version and OS version, it makes a difference.

wheres perry when you need him?

You can restart a log chain by issuing a differential backup, so a switch from bulk-logged to simple and back again will not break a differential chain. The base LSN...

.........which is why I have flat file backups of the SAME server, then I don't have to take master DB files from other servers or worry about versions.

and remember the...

Brandie Tarvin (6/20/2011)

---

george sibbald (6/15/2011)

---

To avoid this problem in the future, next time your instance is down take a flat file copy of the system database files to another directory...

At some point that directory existed and may have been defined as the default location for backups.

create the directory 'Z:\Backups and give SQL permissions to it, the message should go

No. It would only be of...

thanks for the feedback folks.

Some interesting viewpoints and thoughts.

@gus

Thanks for your input.

I think the type of work our devs are doing must differ greatly from yours (more ETL processes), and I have never had a dev say...

no probs

thanoseft (6/17/2011)

---

Hi, thanks for the reply!

What you mean is that the database after the restore will look exactly the same as the production one, as long as the directory can...