When we had a cluster, we used Norton AV. Now that we can't use the cluster, we still use Norton AV.

When we first set it up, we had lots of...

You need to give us more information about your setup.

You have a cluster, so you are using shared drives. Are the log files on the shared drives?

-SQLBill

If the restore fails, you can't use the database - it never restored. SQL Server is usually an 'all-or-nothing' system.

-SQLBill

I suggest beginning your code with:

SET DATEFORMAT YMD

<rest of code>

Setting the dateformat tells SQL Server how to interpret the date value you are providing.

-SQLBill

Since single-user means only one connection can exist, yes it is very restrictive. You should be able to restore using single-user mode without any problem.

-SQLBill

I don't use log shipping, but if it is running at the same time your backup is running, then YES that's most likely the problem.

How to test? Change the time...

Most likely you are having network problems...too much happening on the network.

You could also check what's happening on the computer with SQL Server. CTRL-ALT-DEL and find Task Manager. Is your...

You do one of two things....

1. you replace <device name> with the path you want to use:

BACKUP LOG mydb TO 'C:\Backups\mydblog.bak'

2. you create a 'dump device' and use that.

Refer to...

Sukhoi,

Please DON'T post the code here. This is a SQL Server forum not an Access forum.

However, if you really must post it....this site does have an Access forum, so post...

I backup my SQL Server databases (and logs) to hard drive and then use Veritas to copy those backup files to tape.

-SQLBill

Sometimes shrinking the database and/or log doesn't happen fast enough. When you absolutely need to shrink it now, truncateonly is the best choice. But I always advocate doing a full backup,...

You have my sympathy, but this is a prime example of why I don't use the maintenance plans nor the 'point and click' shortcuts in Enterprise Manager. Too much chance...

I like to read the rants also (well sometimes), but when there's 50 posts and 40 of them just say I want my points back, that's a waste of my...

Even if you lose the .mdf file you might be able to do a log backup. Remember the schema is kept in MASTER, so when the backup is run, Master...

Please post your questions in an appropriate forum. This forum is dedicated to the Question of the Day - which is a daily question about SQL Server. Everyday SQLSeverCentral posts...