This link has code for any type of backup.

Backup SQL Server Databases

http://weblogs.sqlteam.com/tarad/archive/2008/08/19/Backup-SQL-Server-Databases.aspx

SQL Agent is not included with SQL Server Express.

dubem1 (1/31/2009)

---

What you be the best syntax?

I need to get from a table, from a particular set of rows, the one with the max date

Syntax 1:

SELECT TOP 1 * FROM...

Shrink DB File by Increment to Target Free Space

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

Jeff Moden (1/30/2009)

---

Oh, I absolutely agree... when someone said that SSC would have 10-15 million members in 5-10 years, I made the correction that it would have 200 users and...

500 GB really isn’t that large a DB. I manage several that are much larger on SQL 2000, and SQL 2008 has many features to make large databases easier...

Jeff Moden (1/30/2009)

---

Sounds like a lot of fun but, consider this, would you like it if your post and name showed up on a "Twit List". Bad enough they...

Is that a serious question, or were you trying to provide an...

I don't think you have all the data in the table that you need.

You can't just use the start time of the next task to determine the end time; some...

There are many ways to do this, but an easy way is to create and populate a date table. You can use the function on the link below to...

Don't worry about the public role. As long as you don't grant any object access to the public role and don't add it to any of the fixed database...

Everything you have described is exactly the way SQL Server Security is designed, and is the same in SQL 7, 2000 , 2005, and 2008, regardless of the SP.

If you...

Should Michael Earl be worried that a...

That is the Target memory. The Total Server Memory is the...

I think you might want to look into "Scalable shared databases", an obscure feature in SQL Server 2005/2008

You might start with looking at this link:

http://support.microsoft.com/kb/910378

It's looks a bit hard to...