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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Backusp

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-05-18 : 06:27:50
I like the topic name!

Does a SQL Server backup have to be on the local machine?

No space left for initial full backup. I want to use a remote server. Right next to it. This is not a big or busy database. 3Gb.

I just can't see, in the windows / wizard, if you can put \\dev-HRWeb/d$ anywhere. It seems to like just local devices. This must be possible! When you have no space, on either C:\ or D:\... what do you do? I am not a Windows Server person. Are you? I'll get this stuff in place, in a day or so - more devices - but can I temporarily save my poor data remotely, maybe after midnight, ASAP..?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-05-18 : 07:32:44
Instead of clicking [...] to choose path and type in a filename you can directly input path AND filename.
I think the dialog is named Target on Harddrive.

That should be no problem if your server can reach the path...


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-05-18 : 07:48:29
Of course. I post toooo kwik. I sensed that it might be a subtle feature to only allow backups to direct physical devices.

Ta
Go to Top of Page
   

- Advertisement -