just to be 100% sure - has the user clicked the plus sign next to databases and expanded the list?

you never know........:-)

is this accessing via SSMS?

do they receive an actual error or just don't get a drop down list of databases?

sounds like the old 80\20 rule.

For any given piece of kit\app we use we only use 20% of its functionality 80% of the time.

Hence the popularity of netbooks recently.

Myself,...

MS want the correct procedure to truncate logs to be setting recovery mode to simple, hence deprecation of no_log and truncate_only.

However dbcc shrinkfile is still available, it would be a...

as this post is a day old I presume you have discovered by now that the log will apply ok.

go straight to SP3. may well fix it.

either you have hit a bug (what version of SQL are you on?) or someone\something is issuing this command. I suggest you run a server side trace and include ...

best thing to do? read this article

http://www.sqlservercentral.com/articles/64582/

If you really need the drive space see dbcc shrinkfile in BOL, but think carefully about how you size the log file

sorry mixing up my threads here.

did you backup the log on the primary with the norecovery option? In that case the database will be in a restoring state and inaccessible...

It worked , but I have a question here,

restoring secondary databases with recovery and route the users—with in this time users will do some transactions in primary server,...

newdb (12/1/2009)

---

Sorry George,

I click the post too quickly. The error I got when I ran the job is:

Cannot open backup device '\\datadev01\d$\DBA\Thitesting\DBA.bak'. Operating system error 2(The system cannot find...

what was the operating system error code? Post your actual error.

good point. Wasn't there a TV/radio program once where you had to do that?

now you've done it! he said don't ask 🙂

having read up on it there are scripts for it on this site and also in BOL under sys.dm_db_index_physical_stats.

Another quick way is to use the reindex maintenance plan task via...