You maps a login or a user to a particular database only after creating the user.

you cant restore the last two transaction log backups taken after B2.

Go to registry -->software-->mssqlserver--> instance there you can find the server name.If you are using SQL Server Express edition then give the instance_name\sqlexpress.

Hope the issues will arise when the database size becomes very huge.

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.