select @@servername from query analyzer

Steve

Here's my script for deleting the old backups (Note that both of these were written by a former colleague of mine, and extensively modified by me.)

Create Procedure af_Delete_Old_Backups (@path varchar(255))

as                       ...

Markus,

Here's the script to create the full backup stored procedure that I use.  With only slight modification, it can be used for differential and transaction log backups as well.

Steve

create proc...

Markus,

I'm sorry that I haven't responded in a more timely manner.  I just checked my e-mail and saw that there were several new responses.  In my situation, I do have...

The best I can offer is - I personally LIKE using SQL Agent to schedule SQL jobs.  It's designed for that purpose, and it works very well (as long as...

You can't apply a differential backup on its own.  Think of it being rather like restoring TLOG backups except that you only need the most recent differential.

What you must...

Is your server exposed to the internet or any other network?  The sa password that you have chosen (based on information provided in the other thread) is highly vulnerable to...

While this doesn't offer any reasons why it is happening, I think the first thing I would do is try to restore one of those backups (obviously not over production)!

Steve

I think the key here is that you are using SQL 7.0 .  With SQL 7.0 the shrink doesn't happen immediately or all at once.  You should see it start...

Jane,

Attaching a single file when your transaction log is available isn't generally a good idea.  It is possible that there are still open transactions in the file.  Go ahead and...

Dareck,

Based on everything that you have said, I would continue to use the attach/detach stored procs.  Its just safer that way.  Since you are simply copying the files, you could do it...

another option...

DECLARE @status AS VARCHAR(20)

SET @status = char(39) + 'ER' + char(39) +', ' + char(39) + 'OK' + char(39)

/*@Status = 'ER', 'OK' */ 

exec('SELECT * FROM...

umm...   replace the "winks" with "close parentheses"

try this...

create  procedure sp_who2c

as

/*************************************************************/                                                                                                                                                     

--                                                  

-- Module Name: sp_who2c       

--                                               

-- Description:

--

--  This procedure is "front end" to sp_who2 which provides

-- logins in order of cpu usage.  also gives counts...

This treats the symptom:

In Enterprise Manager, click on Tools, Options and make sure "Server Registration Information" has "Read/Store Locally" selected.