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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-01 : 08:47:03
|
| Yves writes "I try to make a backup of a SQL database on a network drive and I always get the same error :BackupDiskFile::CreateMedia: Backup device '\\NASSERVER\myDB\myDB.bak' failed to create. Operating system error = 53(error not found).BACKUP failed to complete the command BACKUP DATABASE [myDB] TO DISK = N'\\NASSERVER\myDB\myDB.bak' WITH NOINIT , NOUNLOAD , NAME = N'myDB backup', NOSKIP , STATS = 10, NOFORMAT I use SQL 2000 on Windows XP homeThe server is a NAS-4100 from ICP ElectronicsThank you." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-01 : 12:19:16
|
| So from the database server, does this path work if you go to Start then Run:\\NASSERVER\myD?Tara |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-04-01 : 12:32:15
|
| Are you doing this manually or is it in a scheduled job? Scheduled jobs run under different user rights and may not have rights to the the network drive.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-01 : 14:01:03
|
| Anyone want to say that this isn't a good idea?How big is the database?Brett8-) |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-04-01 : 14:13:58
|
quote:
Originally posted by X002548
Anyone want to say that this isn't a good idea?
OK... This isn't a good idea.I had that in the back of my mind, but don't have the actual experience to back it up...--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-01 : 14:20:31
|
| The bad idea part is that backing up to a network resource will be slow. You might also experience network problems causing the backup to fail. Due to these, it is better to backup to a local drive first, then copy the file to the network resource.Tara |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-04-01 : 15:42:41
|
| That all depends on the network structure. I am assuming that the NAS part of NASServer is for Network Attached Storage, which, before the advent of SANs, was the way to store large vollumes of data.Connect it with fibrechannel and I would bet it's not too slow.But permissions are the bane...you have to make sure that both SQLServer and SQLServer agent are logged in as accounts with permissions to write to that drive, or you invariably run itno problems. |
|
|
|
|
|
|
|
|
Backup on a network drive