[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2005 - File move to New Server

Posted on 2009-04-17
1
Medium Priority
?
244 Views
Last Modified: 2012-05-06
SQL 2005: I want to backup and restore databases on a new server. Is there not a simple script that can be written to move the .bak file from Server A to Server B? Can some supply?
Thank you
0
Comment
Question by:SeTech
1 Comment
 
LVL 6

Accepted Solution

by:
mvgeertruyen earned 1500 total points
ID: 24169471
Ongoing you mean (as in daily)?
I use SQL jobs:

Source server:
- SQL Step: BACKUP DATABASE <<DB>> TO DISK = 'F:\DB.BAK' WITH INIT, COPY_ONLY
- OS Command: copy F:\DB.BAK \\remote server\writable share\

and then a restore job on the remote server
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Integration Management Part 2
Loops Section Overview

865 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question