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.
| Author |
Topic |
|
feejaz
Yak Posting Veteran
68 Posts |
 Posted - 2010-01-28 : 08:42:13
|
| I have SqlServer 2005 Standard EditionInstalled on the local pc. A Database is deployed on the hosting company's machine and have Sql Server 2005 Express editionI have a website and an MSSQL database which is hosted with a hosting company, I am using microsoft sql studio express to connect to a database, but I am unable to do the backups of the databse as I do not have the permission to access the drives on the remote server and mssql studio STANDARD does not have the option to back up the database from remote server to my local pc. So is there any software available from microsoft or 3rd party software which would enable me to backup my database and if would have a scheduling option it would be even better so i can schedule it to do daily backups.I have got a link to resolve my problem that is http://support.microsoft.com/kb/555128I tried like below:1- Create and share folder on my drive (c:\backup) 2- Then i go to the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup and in folder properties, I have got the user name of SQL SERVER and assigned this user to "c:\backup"3- Then I access the database from hosting machine using SSMS. And try to create backup of required database.(I am able to do create, update, delete, select on this database).4- I got the error as "Cannot open backup device'\\192.168.1.105\backup\abc.bak'. Operating system error 1326 (Logon failure: unknown user name or bad password.)"Need helpNavi |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-01-28 : 15:32:06
|
| The issue is that the user that the SQL Server Agent (? if I am wrong correct me) is running as is not able to access the backup folder. Make sure the agent is running as a domain account with permissions (NTFS and Share) to the backup folder. |
 |
|
|
|
|
|
take backup on local pc from remote hosting machne