You said:

Data file grows to 71 GB,

Transaction log file grows to 57 GB,

are those the actual SQL Server files (.mdf and .ldf) or are they the backup files?

If they are...

How are you doing the backups?

To backup MS SQL you must do one of three things:

1. use the 'native' BACKUP DATABASE commands.

2. detach the database and backup the .mdf and...

Have you double-checked to make sure this file does not exist?

'C:\Program Files\Microsoft SQL Server\MSSQL\data\db_papoulias_gr_log.ldf'

It looks like SQL Server thinks it still exists.

-SQLBIll

Marcus,

The default instance gets the TCP Port of 1433. The next instance gets a different Port. My Ports are correct.

Here's the solution:

1. My database 'lost' it's owner in the move....

There is an option in Backup Exec (I've never used the option myself, so check out your documentation) to restore to a different location; it's similar to SQL Server's WITH...

I'm the job owner. I've stopped and restarted all services several times during the day while trying to solve this.

I'm going home soon (hopefully). I'm running the backups as me...

The backup is being done to a device in the new drive array. I recreated the devices (sp_addumpdevice) when I moved the database.

Also, the backup does work if I do...

A lot depends on your application. I have an application (third-party screwup) that runs using PUBLIC! It give PUBLIC access to just about everything. Can I change it? No way...the...

Everything worked fine until the database was moved to a new virtual server and a new array. ODBC connections worked before the move. And the ODBC connections don't change from...

Here's more information:

I have a job set up that backs up this database. It's set to run as DBO. It fails. I run it under QA as me and it...

Here's more information:

I have a job set up that backs up this database. It's set to run as DBO. It fails. I run it under QA as me and it...

Any restoration, disaster test, etc HAS to be done on the production system since I don't have a test system. Management has never seen a reason to buy a test...

We performed it once to make sure my backup and restore method actually worked. Since then it's never been tested.

24x7, 225 GB. If I take it down for any amount...

I'm running the backup as a scheduled job. It's step 6 in a 6 step job. All steps are database backups and 6 is the only one that fails.

The only...

I'm a member of SSWUG. I'm not renewing my membership. I don't like the site and haven't used it in the last 6 months. I've never gotten an answer to...