You just closed it. By telling everyone you solved the issue, no one else 'should' respond any more.

-SQLBill

Do you have write permission to the files?

-SQLBill

I would just reinstall the client tools. Use the install disk, you'll get a screen asking if you want to install: Server and Client Tools, Client Tools only, and something...

Run sp_spaceused on the database. See the BOL for the syntax. That will show what space is being used for what. If it shows you have 2GB being used, check...

Are you sure it's using 1434?

Normally, SQL Server uses:

TCP 1433

UDP 1434

-SQLBill

It could be a problem with Enterprise Manager. You could reinstall just the client tools. Use the install disk, select install and when it asks you what to install,...

It won't cause any problems, except the Log file could grow larger. You will have to do log backups on a regular basis.

-SQLBill

Are you checking to see if the job is enabled? If it's not enabled, it won't know the next run date/time. Also, the first time it's scheduled, the next run...

It can make queries run quicker. Look up .ndf in the BOL (you don't use additional .mdf files. You have one .mdf and several .ndf).

-SQLBill

What value are you inputting for @START_DATE?

Run this and see what it returns: (replace the ? with the actual value)

DECLARE @START_DATE DATETIME

SET @START_DATE = '?'

SELECT CONVERT(VARCHAR,@START_DATE,101)

-SQLBill

Which database? Some system databases cannot have the log backed up. Master is one. It is always in SIMPLE mode.

-SQLBill

I'm not sure you'll be able to do it. Windows Authetication is just that. It authenticates via Windows. SQL Server doesn't know or trust the application.

-SQLBill

That's the query as run in QA, correct? When you make it a stored procedure, do you add anything?

Are you running the stored procedure from QA or Enterprise Manager or...

1. Make them do a consistent number of backups.

2. check the BOL for RESTORE HEADER ONLY (and there's one other RESTORE something ONLY). One of those commands just gets...

You already have SP4 installed. That's what the 2039 is telling you.

Run this:

SELECT ServerProperty('ProductVerion'),

ServerProperty('ProductLevel')

One will tell you the SP level. The other gives...