View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 05:51 AM
Mist in the night
 
Posts: n/a
Default Two questions about SQL Server 6.5

Hi,

I copied the DATA directory from a backup ghost image to a new SQL
6.5 installation and, after fixing a problem with the directory structure
(which caused the databases to be marked as "suspect") I was able to work
with it in a normal way.

Opening the company database works without problems. The DATA
directory seems to be correctly copied. The only problem is that I'm unable
to see the scheduled tasks. I'm a using predefined database user (not sa).

My questions are:

1. Is it normal not to see the scheduled tasks when logged as
another user than the sa or the owner of the tasks ? If it isn't, then
something went wrong copying the DATA directory (even if SQL didn't mark
them as suspect). Any advise or comment about this would be really welcome.

2. If it's normal not to see the scheduled tasks, Is there any way
to recover the lost sa password ? The docs containing the password were
lost around 4 years ago.

Any help would be really welcome,

Reply With Quote