Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Failed to take backup

Author  Topic 

Ali80
Starting Member

9 Posts

Posted - 2007-05-05 : 04:53:02
Hello

I have a problem with the backup. I made a new MaintenancePlan to take backup of the databases, but everytime I get an erroe message which it say's:

"[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'Domain\Administrator', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)"

"[298] SQLServer Error: 3621, The statement has been terminated. [SQLSTATE 01000] (ConnIsLoginSysAdmin)"

I tried to find out the problem but I couldn't. Is it something with AD in our domain or with the owner of the databases?

I hope if someone can help me..

Thanks

Ali

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-05 : 12:41:28
Who is job owner? Change to sa then try again.
Go to Top of Page

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-05-06 : 15:19:21
check the following thread...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1450867&SiteID=1


MohammedU
Go to Top of Page

Ali80
Starting Member

9 Posts

Posted - 2007-05-07 : 08:35:39
Hello

I want to thank u both for ur anwsers and ur time.
It is working now.. Both of ur anwsers helped me to find the problem

Thanks again

Ali
Go to Top of Page
   

- Advertisement -