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 |
|
rrober07
Starting Member
3 Posts |
 Posted - 2003-04-16 : 10:40:30
|
One of my co-workers is having a problem with SQL Server when creating a backup and log files. He is getting an Error see attached screen shot. It is happening when he tries to create these backup/Log files on a network device…we can’t figure out why… We have tried using Mapped drives and UNC path \\Server\Share names. Is there something that we are missing.. any help would be greatly appreciated. Let me know if you need more info. Thanks!Richard |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-16 : 12:08:17
|
| Well what's the error (attached screen shot isn't showing up)?Tara |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2003-04-16 : 12:25:37
|
| Without seeing the error, it's obviously hard to tell. But I'm wondering that if you're doing this from a job, the server you're trying to move the file to doesn't accept your sqlserver agent login and so it can't access it to write a file. Just a shot in the dark(which I've learned from experience).Mike"oh, that monkey is going to pay" |
|
|
|
rrober07
Starting Member
3 Posts |
Posted - 2003-04-16 : 12:35:38
|
| Sorry about the Screen shot...I guess it didn't work when I uploaded.The message says: Error 5110: File 'G:\TestMapDrive_Log.LDF' is on a network device not supported database files.it also gets the same message when I use UNC \\Server\sharename...ThanksRichard |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-16 : 12:42:11
|
| Is your co-worker trying to backup the database to a network location or create the database on a network share? Here is some info:[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;304261[/url]If that article doesn't help, then what is the command that your co-worker is running? If he is doing it through Enterprise Manager, then please explain the steps that he does in EM to get the error.Tara |
|
|
|
rrober07
Starting Member
3 Posts |
Posted - 2003-04-16 : 13:39:00
|
| Tara,He is trying to Create a DB in Enterprise Manager...He is trying to setup the Transaction logs on another server to offload the work on the local drive. It is in the Transaction Log <TAB> when he tries to change from the currently location to another location...when the error occurs.Thanks!Richard |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-16 : 13:48:45
|
| Well you can not create a database on a network drive unless it is a SAN (please see the article). The database files need to be stored on the local drives. If he wants the database file and the transaction log file to be on separate drives, then just create another array (will need a separate controller to benefit though) for it.Tara |
|
|
|
|
|
|
Transaction Log/Backup on Network Error