AM citit ca acest lucru e posibil in sql 2005.Am facut un backup device care bate catre un share valid din retea,si cand am incercat sa fac backupul la baza d edate pe acel device mi-a dat eroare.

Ce stiti este posibil acest lucru sau nu?

 

---

Secolul XXI ori va fi religios ori nu va fi deloc

Merge! Vedeti aici: Backup Devices 

Backing Up to a File on a Network Share

For SQL Server to access a remote disk file, the SQL Server service account must have access to the network share. This includes having the permissions needed for backup operations to write to the network share and for restore operations to read from it. The availability of network drives and permissions depends on the context is which SQL Server service is running:

• To back up to a network drive when SQL Server is running in a domain user account, the shared drive must be mapped as a network drive in the session where SQL Server is running. If you start Sqlservr.exe from command line, SQL Server sees any network drives you have mapped in your login session.
  
• When you run Sqlservr.exe as a service, SQL Server runs in a separate session that has no relation to your login session. The session in which a service runs can have its own mapped drives, although it usually does not.
  
• You can connect with the network service account by using the computer account instead of a domain user. To enable backups from specific computers to a shared drive, grant access to the computer accounts. As long as the Sqlservr.exe process that is writing the backup has access, it is irrelevant whether the user sending the BACKUP command has access.
  

  Important:
  Backing up data over a network can be subject to network errors; therefore, we recommend that when you are using a remote disk you verify the backup operation after it finishes. For more information, see Verifying Backups.

   

Specifying a Universal Naming Convention (UNC) Name

To specify a network share in a backup or restore command, you should use the fully qualified universal naming convention (UNC) name of the file for the backup device. A UNC name has the form \\Systemname\ShareName\Path\FileName.

For example:

BACKUP DATABASE AdventureWorks 
   TO DISK = '\\BackupSystem\BackupDisk1\AW_backups\AdventureWorksData.Bak';
GO

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

deci eu sunt logat intr-un domeniu nt cu un useracount.AM sql express edition si vreau sa fac un backup direct pe un share in retea unde am eu drepturi cu acestr cont.AM pus sql server sa ruleze ca si contu meu de domeniu am facut un backup device caere bate pe shareul ala care e accesibil de mine din nt ,dar procedura de backup imi da eroare imi spune ca nu poate deschide device-ul

---

Secolul XXI ori va fi religios ori nu va fi deloc

Ce cod folositi exact?

Ce mesaj de eroare obtineti (exact)?

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

NU folosesc cod.AM definit un baclup device care bate pe un unc de forma:\\fileserver/ape/temp/alexandru.pascanu.AIci eu am acces cand ma loghez cu contul meu deactive dir.AM creat backup device sa pointeze pe shareul asta am pus serviciu sqlexpres2005 sa ruleze ca si contul meu de user cu care ma leg dar cand vreau sa fac backup la acel device din sqlmanagemnet imi zice ca nu poate deschide backup deviceulmai exact:

"cannot open backuo device testari(\\fileserver/ape/temp/alexandru.pascanu) Operating system error 5 (error not found) (microsoft.sqlserver.express.smo)

---

Secolul XXI ori va fi religios ori nu va fi deloc

Codul urmator va merge?

BACKUP DATABASE AdventureWorks
   TO DISK = '\\fileserver\ape\temp\alexandru.pascanu\AdventureWorksData.Bak';

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

Multumesc ,

asa a mers totusi nu inteleg de ce nu a mers si din management studio

---

Secolul XXI ori va fi religios ori nu va fi deloc

Exista o diferenta subtila intre:

\\fileserver/ape/temp/alexandru.pascanu

si

\\fileserver\ape\temp\alexandru.pascanu

Varianta corecta UNC este a doua.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro