Intrebari generale

Re: backup device care sa pointeze catre un share in retea

xmldeveloper — Fri, 24 Nov 2006 16:33:55 GMT

Exista o diferenta subtila intre:

\\fileserver/ape/temp/alexandru.pascanu

\\fileserver\ape\temp\alexandru.pascanu

Varianta corecta UNC este a doua.

Re: backup device care sa pointeze catre un share in retea

crestinul — Fri, 24 Nov 2006 14:33:40 GMT

Multumesc ,

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

Re: backup device care sa pointeze catre un share in retea

xmldeveloper — Fri, 24 Nov 2006 14:21:32 GMT

Codul urmator va merge?

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

Re: backup device care sa pointeze catre un share in retea

crestinul — Fri, 24 Nov 2006 12:57:08 GMT

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)

Re: backup device care sa pointeze catre un share in retea

xmldeveloper — Wed, 22 Nov 2006 10:48:27 GMT

Ce cod folositi exact?

Ce mesaj de eroare obtineti (exact)?

Re: backup device care sa pointeze catre un share in retea

crestinul — Wed, 22 Nov 2006 10:16:50 GMT

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

Re: backup device care sa pointeze catre un share in retea

xmldeveloper — Wed, 22 Nov 2006 08:43:56 GMT

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

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.

backup device care sa pointeze catre un share in retea

crestinul — Wed, 22 Nov 2006 07:17:58 GMT

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?