I'm not an expert on these types of problems, but it sounds to me like it may be an MDAC version problem.  As a test, you could upgrade the MDAC...

David,

Just ask them what you should do if you restore the full backup, wait a while allowing him/her to update his/her data, then place the database in STANDBY, and restore...

Mike,

Take a look at your Recovery model.  Its Simple, isn't it?  In the Simple recovery model, transaction log backups are not possible because SQL truncates the transaction log at each...

David,

The answer would be the same whether transaction log backup or differential.  Either way, SQL must ensure that there was no possibility of updates between restores, so the only...

Look at @@ERROR in Books Online.  Might give you what you need.

Steve

You can take it offline, or put it in read only or single user mode, but I think thats not what you're looking for.

I assume you have restored a full...

Just because the account you created has rights to the mapped drive, doesn't mean that the account can see the mapped drive.  If you mapped the drive while logged in...

I think probably the problem is with your DTS package.  DTS runs in the context of the person/machine running it.  If your flat file is on the c:\ drive of...

Renaming the table is one of those things that works, but probably not why you think it is.  I could be wrong, but my bet is that it works because...

This oughta do it...

SELECT

 [filename],

 [Location],

 [filesize_kb],

 entrydate,

 DBFileSizeID,

 CAST(serverproperty('servername') AS varchar(20)) AS "DBServerSource"

FROM [DBFileSize] dbf1

join (select max(entrydate) as maxdate from dbfilesize) dbf2

 on dbf2.maxdate = dbf1.entrydate

WHERE CAST(entrydate AS char(11)) = CAST(GETDATE() AS char(11))

AND filesize_kb >...

Well, given the choices, I like AJ's answer (in the other thread).  But, how about option 3?

With the scenario you have given, the user is still filling the form, and...

So, the pre-production name would be "Big Brother"????

Steve

Wanderer,

That's exactly what I have!  My "DBA" database holds all my maintenance procedures as well as supporting tables which control my backups, reindexes, configuration monitoring, etc.  It works absolutely...

rpetty,

I can't answer with regards to Microsoft's canned log shipping.  What I can tell you is that I am using "home-grown" log shipping.  Log backups occur every 15 minutes, and...

Might be a good plan, if you're not doing log shipping.  The problem is that as soon as you do a truncate on the log, your transaction log backup chain...