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 - 2003-07-23 : 07:29:11
|
| Mohammad writes "Dear Sir/MadamI want to backup from SQL Server DB across the network.I have 2 machines in network and i have SQL server only on one of them.I want to schedule backup from one machine to other.if it is possible , please guide me step by step for scheduling backup DB.Best Regards Mohammad" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-23 : 12:17:55
|
| Why don't you just backup the database to the local disk and then copy it to the other machine? It is much faster to backup the database to disk than to backup it up to a network drive. BACKUP DATABASE DBNameTO DISK = 'F:\MSSQL\BACKUP\DBName.bak'WITH INITxp_cmdshell 'xcopy F:\MSSQL\BACKUP\DBName.bak \\SomeServer\Someshare'Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-23 : 12:37:27
|
| Bet there's no room on the SQL Server drive....If so, You'll need to make roomOr can you map an external drive and dump it thereAnd Tara's correct though...dumping across a network will be slow.Plus won't there be possibilities for a hickup that will corrupt the dump?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-23 : 12:40:18
|
quote:
Plus won't there be possibilities for a hickup that will corrupt the dump?
Yes definitely. If Mohammad does not have enough disk space on the server, then he should clear some up like you mentioned or add some because you don't want to be in his position when you need to restore the database but the backup failed because the SQL Server couldn't find the server where the backup goes due to network problems.Tara |
|
|
|
|
|
|
SQL Backup