Do you backup to tape or disk?

If to disk, does your backup job create new files each time or just append to the original?

The removal of old backup files (using...

Paul,

You can get the MS SQL Server Books On Line from this MS website:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

SIVAPRASAD,

What does you license cover? Is it Per Seat or Per Processor? I'm guessing it's Per Seat....when you set up your SQL Server how many seats did you say to...

Leslie,

Don't call MS....you have a license that allows 10 connections, so of course the 11th connection will fail. It doesn't matter if there are 9 users actively using the database....

Sometimes I'm able to hit the BACK option and go back one or two screens and see what I typed....I just highlight it, copy, go back to the original thread,...

The transaction log grows with every DELETE, INSERT, or UPDATE (in other words ANY transaction) that you do to the data.

You can SHRINK the transaction log.

You can TRUNCATE the transaction...

That's because Microsoft no longer supports those Operating System versions.

-SQLBill

Oh why didn't you post this sooner?

I submitted my request two weeks ago and would have used the SSC code if I knew...

You need to post this question in an appropriate forum. This forum is specifically for discussing the Question Of The Day test question.

-SQLBill

Server name and IP are changing, but that should be it. Master,Model, and MSDB are currently on the C drive and I intend to put them on the C drive...

Try SET NOEXEC ON. But as I recall, TSQL commands can't be 'precompiled' like other languages. SQL Server only holds the compiled code for a short time. SET NOEXEC ON...

Maybe it's something in your backup script or a script that runs just before your backup.

Does your script stop any services? (MSSQLServer and SQLServerAgent services need to be running).

Is your...

Full access meaning what? If you mean full access on the computer, that's not good enough. If you don't have the proper access on SQL Server, you probably won't be able to...

Margaret,

I agree with Steve (hoo-t), the issue is your REINDEXing. When I do a DBCC REINDEX my t-log gets HUGE. Try this...turn off your REINDEX job. Shrink the log. Let...

Are you backing up to disk? Are you appending or overwriting? If you are backing up to disk and allowing append, then the date/time of the backup file changes to...