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 |
|
shadhin
Starting Member
1 Post |
 Posted - 2006-06-24 : 15:40:20
|
| Can anyone help me about remote database backup?I have around 30 sites. I have to backup individually on after finishing the work using Terminal Services. There is no fixed time to backup. Different branch close in different time. Is there any way to backup from remote site ? Backup will store at local Disk then it will copied to Disk. I'm using SQL 2000 and Windows 2000 Server. Please help me. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-24 : 20:16:59
|
| Why not just schedule the backups on the remote servers to run as SQL Server Agent jobs?It's fairly easy to setup scheduled backup jobs with the database maintenance wizard.CODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-25 : 00:30:26
|
| "Why not just schedule the backups on the remote servers to run as SQL Server Agent jobs?"+1That's what we do ...Kristen |
|
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-06-26 : 04:10:47
|
| Back them up using maintenance wizard as suggested or back them up locally then have a Ntbackup job that copies them from remote to your localRegardsNThe revolution won't be televised! |
|
|
|
sanket_sirotiya
Starting Member
1 Post |
Posted - 2006-07-20 : 08:01:20
|
| I am also stuck up in the problem: Remote databse backup....I read your suggested article http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=33&rl=1 throughly. I issue comes here: When I login to the Enterprise Manager->MSSqlServerGroup->Management-> here there three options 1)Sql server agent 2) BackUp 3) Current ActivityBut dataBase MAintaninace Plan is missing!!!But tried to backup my database through Backup but i dont have sufficent permissions since its a Web Farm!!!I need to back up my DataBase, but do not want to Import/export database! just Back UpThanks in AdvanceAttitude Not Aptitude Determines Your Altitude |
|
|
|
|
|
|
Remote Database Backup to local Disk