I think u have remove the publication first before restoring the backup.

Thanks alot buddy....:)

That means only dbowner and roles above that can restore a database right..

Created a user with backup operator rights,the problem is when it comes to restoration.I think we have to kill other process to restore the database, which is not possible with...

Can a backup operator role restores a database

Hope this is not the place to put advertisements and job oppurtunities...

When u create a database user u can give that user certain roles like db_owner ,db_ddladmin etc.These roles are fixed and u cannot add any more roles to that,out of...

Dont u have mail configures on ur system???

Hope u have outlook express on ur machine and mail configured on that..

Database Mail and SQL Mail both are different and DB mail requires SMPT Server.Higher versions of SQL Server dont have SQL Mail by default.

Check these links

http://technet.microsoft.com/en-us/library/ms175887.aspx

http://technet.microsoft.com/en-us/library/ms177418.aspx

Thanks Everyone

I have solved the problem by copying the LDF to another drive and then attached the database giving the new LDF path.

i made the server connections to single user mode so there is no other connections to that i feel.

Hi,

SP3 of SQL Server 2005 is expected to be released by next month only

Thanks Dude it worked..

Those DB having autoclose option False are not able to delete only those set to true got deleted.

Ya i find that in OPTIONS ..It is presently FALSE.