I suspect that what was meant was that less experienced SQL DBA's, or people thrust into the role of DBA are the "weekend warriors" trying to make things work without...

Why do you say they have no .MDF ? Look at the properties of the database to see what it's using for .MDF files. Maybe they are named differently than...

Perfect ! Thanks !

Is that what I should have done earlier, or would there have been a better process at the time ?

My BOOT.INI is:

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect

We're running VMWare, if that makes a difference.

It means Reboot.

Or drop it from 5 feet and see if that resolves the issue.

Are you backing up to disks that are also used for other purposes ?

Backing up across a slow network ?

Buy 3rd party backup software.

I'm probably veering a bit off topic, but if you only need a subset of Production for reporting, replication is an option. This can be useful to bring over only...

Rather than dig up a 4 year old thread, I think you would be better served by starting a new thread based around your own question, and putting it in...

You did not look very hard.

More options:

- After the backup completes, add a step to move it to tape or another drive with more space.

- Purchase 3rd party backup software that will compress the backups.

-...

I'm not clear on a few things (but that's just me)

"... the staging db is backed up and restored into production ..."

Does this mean you do RESTORE DATABASE from your...

Back to the OPs backup schedule. I think I read that you are only doing FULL backups 3 times a week ? If data changes frequently, and especially if this...

If you only have 4-5 days of history, then you need to increase the # of rows to retain on that same screen.

We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions...

A simpler, but less robust method would be to:

1) Take a backup to MyDatabase.BAK

2) Create a BAT file to copy MyDatabase.BAK to the target server

3) Run a T-SQL script to...