Hi,

You can create a sql statement :

select avg(state) from <table>

where date between <date1> and <date2>

--Kishore

Try copying the .mdf file to soem other location and then attaching it using SQL EM.

I dont see any other issues as it has been detached and then sent...

Hi,

Where did you the get the .mdf file from ? I mean was it copied from some other server ? And how was it copied ? Was the SQL Server stopped when...

Hi....You can also attach it using EM. In EM, Under Databases -- right click ----All Tasks -- Attach Database. Here we specify the .mdf file to be attached and specify...

Hi,

what is the command you are using to attach. You may try this one :

EXEC sp_attach_single_file_db @dbname = 'dbname', 

@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

@physname will have the entire path...

I did some research on Yukon.

I could find a substitute in YUKON (grant CONTROL to mbt_user) which I guess works the same way as ALL in earlier versions of sql server...

Hi,

Do you the backups of the database with you. If you can give the details of the backup like Full, Differential and Log backups, I can provide details how to...

Hi....Greetings !!

You may also try using SQl-Backtrack for SQl-Server.

Its a BMC Software product with many capabilities that the native sql server does not provide.

You can download a trial version of...

Ok.You mean to say that if a trnsaction starts at 10:05 and ends at 10:20 will also be a part of the backup file.

Thats great. I think I am clear now.

Thanks...

This is great work..Thanks Robert.

Yes, you can go ahead and use the sp_attach_single_file_db stored procedure and just refer the .mfd file. YOu can get the sntax of it from BOL.

It will automatically create .ldf...

You cannot do inidividual object backup/recovery in sql 2000.

You need to take full backups.