Did you recently move your .ldf file for the database without detaching it?

Do a search and see if you can find your .ldf for the database. Is it where it's...

I don't know, I have never used the database maintenance plan wizard. I do all my own BACKUP commands and turn them into jobs run on my schedule.

-SQLBill

First, you say you are backing up the transaction logs and sending them.

Did you ever do a FULL backup and send that? You CAN NOT restore transaction logs without first...

The issue is that you are saving all the backups to the same file. SQL Server has to delete all or nothing. So, let's say you have RETAIN 1 day.

You...

Good article. Two typos that I noticed. One minor, one not so minor:

Minor: Use IsNull (set @SomeVar = IsNull(@SomeVar, '') + Isnull(@SomeVar2, '')  should have an additional&nbsp

You CANNOT apply a differential without applying a FULL backup.

If I understand you correctly, you made a full backup and restored it to a 'backup' server. Now time has gone...

What version of SQL Server are you using?

For SQL Server 2000, the backup files for FULL, Differential, and Log files are all .bak. At least mine are.

If your database is...

You are creating a LOCAL temporary table. The table isn't usable outside the SCOPE that it was created in.

Try making it a GLOBAL temporary table. Use two #'s (##temptablename) instead...

Raid 5 is nice because it allows you to lose one disk without losing data. Two disks you lose everything. UNLESS, you have a hot spare. Then you can lose...

I would not use a 6 character password. We require no less than 8 characters and I require (and use) 12 character passwords for SQL Server. The passwords must have...

Steve,

Synonyms in Oracle allow you to 'mask' your object names. Most of us use distinct naming conventions for objects, such as tblAddressBook.

Users only see the synonym and not the 'real'...

How are you doing the backups? Are you using SQL Server backup commands or are you using third-party software?

-SQLBill

In Windows, right click on My Computer icon, select Manage, find Services. Find the SQL Server services and see what login they use. You need to be a member of...

1. How do you do you backups? Via SQL Server commands or via third-party software? Do you take the server off-line/detach databases?

2. Any idea what else happened last Thursday? Did...

Brian,

I can understand you not wanting to lower points 'mid-stream'. However, the contest ends and begins anew each month. There is nothing wrong with getting all the input you can...