Hi Mardus,

Thanks for the info..

Do u have issue only when u take log backup or all type of backup??

Is that will any particular database??

If yes please provide the structure of...

First thing u should check is the error logs..

Post wats there in that error log..

Can u please tell me what exactly u trying to achive??

Why Full-diff -full and then log...

U CHANGE THE OWNER BY

use master

GO

EXEC [DB_NAME].dbo.sp_changedbowner @loginame = N'LOGIN_NEW', @map = false

GO

You can give specific alter permission to that table

create a table having similar strucutre as that of the file and then using bcp insert the data??

Thanks Jeff.That was really nice example and i liked the way u explained simple but really powerful so that noone will forget

Can you please let me know how to group users??

Chechk this link

http://msdn.microsoft.com/en-us/library/ms186865.aspx

you can understand each and every options of a backup

NOFORMAT keeps the media header(default)

NOINIT options appends the backup to existing backup(default)

Do u have enough permissin to that location??

not every users but most of the users...

Thanks Perry..

What if we need to give different usrs diffrent privileages??

Can we give different privileges to different users using same role?

Have u tried using SSMS??

16 is right for sp_attach_db

check my blog

http://rknairblog.blogspot.com/

You can detach and move the files to new loation and attach ..You can specify the location when u use the GUI