Look to see if you have Cluster Manager. If so, open that and find the resource for SQL Server and see which node (server) is shown as active.

-SQLBill

Depends on what you want the front-end application to do....

Crystal Reports is great for making reports and charts.

-SQLBill

Okay, the 2pm Full backup is not any good for you. Forget about it.

You need to backup the current transaction log if you can.

Restore the full backup from BEFORE...

Sure, IF YOU DON"T WANT BACKUP EXEC TO WORK ANYMORE! (sorry for the all caps, I just want to emphasize what I'm saying).

Those files are necessary for Backup Exec 9.x...

Let me look into my Crystal Ball.......ummm I see that you have Veritas Backup Exec 9.x installed.

Read your documentation on BE 9.x. It says that if you have to restore...

Post examples of how your dates currently look. That will help us come up with a way to convert them to DATETIME.

-SQLBill

You can run BACKUP LOG xyz WITH TRUNCATE_ONLY.

That will free up some space. However, you need to find out why the log file is full.

Are you doing backups? If not,...

Check out the SQL Server Books OnLine.

It's installed as part of the Client Tools and can be found at Start>Programs>Microsoft SQL Server>Books OnLine.

Or go to Microsoft's web site. Search for...

I don't use network utilities, so I can't help with that.

However, what Port does your home SQL Server use? If it's the default then it's listening on 1433. Check...

DOH! I can't believe I missed that. Thanks for catching and figuring it out.

I'm glad I was able to point you in the right direction.

-SQLBill

Try this:

DECLARE @mydate VARCHAR(10)

SET @mydate = '2004-05-21'

SELECT GETDATE() - (DATEPART(DW, @mydate) -1) AS Sunday,

           GETDATE() + (7 - (DATEPART(DW, @mydate))) AS Saturday

-SQLBill

First, have you ever done a full backup?

If not, that's the very first thing you need to do. And do it right now.

Then backup the transaction log.

It's very easy to...

Or if you do have enough space, you don't have TEMPDB set to automatically grow fast/large enough.

-SQLBill

You've set it right and it's not the max allowed that is the problem. You probably have the database set to autogrow. What is it set to grow by? With...

Peter,

Transaction logs have to be applied to a full backup that was done BEFORE the transaction logs are backed up. This is why SQL Server advises that you backup your...