Sorry ... my typo ....  I meant Enterprise EDITION, not EM ....  d'oh  !

Thanks for the other suggestions ....  I 'll be trying it later today.

We're using enterprise manager, actual build # is 9.00.1399.06

SSIS works if I log on to the server directly, but I get an access denied error if I try it from my...

Maybe I can script the process into a job, running under an account that has permission, and just let him start the job ?

We're on Veritas BE 9.0 and  have done restores here & there without any problems.  In our case, we're only putting the databases on tape. For those few DBs that...

" .. Also, I have gathered this much that if I want to create groups, I need Active directory. Can any one please elaborate on this. I am looking to...

Thanks.  I went into the surface area config tool, and I see that Database Engine and Analysis Services both expand and have a sub tabs to enable Services and Remote...

One area I consider lacking in SQL ........   One of the things I miss about our AS400 is the depth of information like "Last Used" data .....

I'm about to install 2005 on my desktop, and notice that it wants to install into the same folder that 2000 is in ( C:\Program Files\Microsoft SQL Server ).  Should...

And if you have a whole lot that need changing, run this in Query Analyzer, outputting to text (not grid), then paste the results into another window to run them...

Could you give some specifics of your situation, such as your DB & T-Log backup scripts,  recovery model and how "important" your DB is.

Are transaction logs "worth it"  ?  It...

The job needs to be enabled AND the schedule needs to be enabled.  Perhaps the job had an end date that has now passed.

And some data is so troublesome that it's just best to delete it all and start fresh.

Pretty simple

1) Detach the database

2) Rename the files.

3) Attach the database. You'll probably have to put the path & file name in the "attch" screen.

4) all done

You said "My production database was set to Bulk-Log recovery model"  (emphasis mine) Does that mean it's not bulk-logged anymore ?    Can you shrink the log.  Have the backup jobs...

Perhaps if you post the exact backup statement(s) and error(s), it will help people get a better understanding.  You might also include the results of sp_helpdb