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
 Express Edition and Compact Edition (2005)
 backup in sql express Vs backup in Sql server

Author  Topic 

MohammadGH
Starting Member

4 Posts

Posted - 2010-01-07 : 07:46:34
i get Error:" can not open backup device " when i try to create backup with sql express in windows directory location, but this backup successfuly created with normal sql server, now whatas different?

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2010-01-07 : 08:33:56

You need to check the security permissions on the folder you are trying to backup to.

Or you have to add the domain account for that

But am not understand what is normal sql server

-------------------------
[R][A][J]

Go to Top of Page

MohammadGH
Starting Member

4 Posts

Posted - 2010-01-07 : 15:57:21
"normal sql server" i mean sql server standard edition.
with this edition i created backup with no error in windows folder and other location, but with express edition i'm can do this.
someone help me???
Go to Top of Page

AlexGreen
Starting Member

8 Posts

Posted - 2011-07-26 : 15:28:36
Keep in mind that what you call "Normal SQL Server" may be running with different permissions to those granted to your SQL Express instance. So check the last has the proper permissions.

On the other hand I recommend you to try SQL Backup and FTP, because you will be able to handle both SQL Express and your "normal server" in an easier way.
unspammed
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-26 : 16:32:57
Go to Top of Page
   

- Advertisement -