January 6, 2009 at 6:23 pm
Dear all,
the database backup is failed after i chanaged the administrator password ,and chanage the long-distance log on user name
we use the SQL Server 2000, and the backup the database to another server
could you help me ?
Thank you very much!
January 7, 2009 at 1:37 am
Do you have an error message or some detailed logging?
Wilfred
The best things in life are the simple things
January 7, 2009 at 1:49 am
How do you run the backup? What is the error message?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2009 at 3:09 am
the database log is as follows:
BackupDiskFile::CreateMedia: Backup device '\\server1011\HLFHB_01025\HLFHB_01025_db_200901070423.BAK' failed to create. Operating system error = 32(error not found).
but there are BAK files in the backup folder,but the size of the backup file .BAK is unnormal
but the automation of some databases is successful,i don't know the reason
i think it is bacause i chanage the amdiminstrator password, i don't know the real reason.
January 7, 2009 at 3:36 am
make sure the password for this account is the same on both servers
Wilfred
The best things in life are the simple things
January 7, 2009 at 9:06 am
Did you try to access the destination folder after password change ?
\\server1011\HLFHB_01025\ The accessibility should be checked in this case with write permission.
January 7, 2009 at 10:09 pm
yes,the password is same. the administrator password is not same between the two servers before i chanage them,but the automation backup databases between them is very successful.
January 7, 2009 at 10:28 pm
Can you tell me the detail? I am can not understanding you very clearly.
Do you meant the security of the backup folder of HLFHB_01021 properties ?
Thank you for your hearty help!
January 8, 2009 at 8:30 pm
now the backup is successful after i restar the backup server.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply