Backing up Remote MSDE databases.
-
Hello,I have one SQL Server on a server. and 3 other (?MSDE?)SQL Databases on pc's in the plant. I make daily backups on the server of the databases. The SQL databases on the pc's(I'll call clients) don't run sql agent. Can I back up these databases from my central server. Each of the clients are(should be) setup alike. So, with my job I would need to maybe zip these files into a file so I know which machine it came from. For example after I backup the master, msdb,and user DB, zip into a file called, pc1, pc2, pc3. Any suggestions? Thanks, Brian
-
you could schedule a job at you "regular" sqlserver and have the steps execute OSQL
to backup the needed databases and then copy them to your safe place.
all steps would be cmdshell steps
step1
Osql -E -S yourMSDE1 -d master -Q "BACKUP DATABASE [yourdb] TO [BackupDevice4yourdb] WITH INIT ,NOUNLOAD , NAME = 'remote Full backup',SKIP , STATS = 10, DESCRIPTION = 'Full Database Backup' , NOFORMAT " -o "C:\SQLBAckups\Mybackups.txt"
stepn
xcopy \\yourmsde1FQN\mssql\backup\*.bak \\yoursafezone\yoursafeshare /c /k /h /v /y
you can also find "dynamic" backup procedures at this site. use the search feature
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply