Thanks Dude its worked liked anything

😀

Can you please explain a bit more on that.

The machine to which i have to take backup is not in the same domain nor it have any domain.When i connect to that machine from the RUN am able...

you cannot connect remotly using alias name.you can connect to server using instance name .

I Think for your purpose you have to dettach the database and copy paste the log file to other array. In that case database will be offline.You can also try...

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...