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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2004-06-23 : 01:19:11
|
| hi,i have website based on sql server database, now i have to take daily backup. how i can take remote database backup through T-SQL or by using query analyzer.thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-23 : 01:39:30
|
| You need to have your webprovider do that. If they have given you access the syntax is:BACKUP DATABASE database_nameTO DISK = '\\server\share\backupfile.bak'MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
database backup