It depends on what edition of sql and windows you are using...

If you are using SQL SE then scrach the folllowing...

If this server is not part of the cluster then...

Take it easy... there is nothing wrong to aplogize...

As I mentioned ... if you want to change you have to use it ALTER DATABASE...MODIFY FILE... command...

Note: When you restore again...

First move this thread to correct topic so that you can get fast and accurate answer...

Did you check in the job step at the bottom of general properties tab...package location...

Check the thread ... it may answer your question..

http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/3226eb8005e7fde6/16704de5c966b523?lnk=st&q=SQL+Server+2000+64+bit+Itanium+installation+error&rnum=3&hl=en#16704de5c966b523

http://msdn2.microsoft.com/en-us/library/ms995334.aspx

sp_helpdb returns two result sets... first resut set NAME column is the database name and should be different....It can't be the same...

Second result set NAME column is names of logical database...

Just I want to make sure you are using 2005 so that i asked to post @@version output...

Try to restore through Query Window using RESTORE DATABASE command...

Are you overwriting the...

I don't think you can write trace data directly to table using procedures...

You can write to a file and use fn_trace_gettable function to copy the trace file to table...

The following script gives you the details with step execution times...

You can modify based on your needs...

select step_name,'run_date'= cast(h.run_date as varchar(8)),  

'run_time'= replicate('0',6-len(h.run_time))+cast(h.run_time as varchar(6)),

'run_datetime' = left(cast(h.run_date as varchar(8)),4)+'/'

  +substring(cast(h.run_date as varchar(8)),5,2)+'/'

  +right(cast(h.run_date...

You Mean your log size is 819200 KB and used log size is 819200 KB?

What is the recovery model of th db?

Tell .ldf file size total, used and free space?

Are...

Please post your requirement and exact question to get correct reply...

What cuased this db to go into recovery mode?

You can use ALTER DATABSE with EMERGENCY option... check BOL for syntax..

http://msdn2.microsoft.com/en-US/library/ms174269.aspx

Note: Before setting it to emegency mode check why...

Did you installed SQL SERVER 2005 sp2 CTP because SP2 is not released?

Post the output of SELECT @@VERSION...

The following article applies to SQL 2000..

http://support.microsoft.com/kb/833710

How is the SNAPSHOT which is doing bcp?

what is very current log size and used size?

how much free space do you have on the disk?

Is transaction log file growth configured...

Your transaction log will not be truncated until the transactions are replicated to subscribers so there is a chance of growing tlog...

As long as you have free space there is...