DTS Package to Duplicate Backup/Restore?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "ML" <schooner@xxxxxxxxxxxxx>
Date: Sun, 21 Aug 2005 10:20:21 -0300

Is it possible to create a DTS package that would basically duplicate what
backup/restore does?

Basically I have a remote SQL Server database on a hosted server that I do
not have direct backup/restore rights too. What I need to do is have a way
to backup and restore this server to a local development SQL Server.

What is the best way to do this with DTS so that it completely copies all
object and data between systems?

.

Prev by Date: Re: Transfering only updated data (from as400 to SQL2000)
Next by Date: Re: DTS Book
Previous by thread: Export to Access Database
Next by thread: passing Server name as parameter to Querry, can't use procedure.
Index(es):
- Date
- Thread

Relevant Pages

Re: Windows forms application and database back-up
... What you write is valid as it is running as multi user source, but as it is single user like the OP wrote, than in my idea simple make copies has the same effect. ... I was also going for the backup/restore, but rejected that because it has in my idea no advantages in a single user situation. ... attached to the SQL Server instance), ... The other option would be to use SQL Server Express' USER INSTANCE, to which, the user do not have to have local admin rigth to attach database to SQL Server Express instance. ...
(microsoft.public.dotnet.general)
Re: Installing SQL server with predefined data
... For the backup/restore with Move route, ... Use RedGate Data Compare to produce a script that inserts ... > We are writing an installation routine for our app using MS SQL server. ... > to have the database ready with predefined data. ...
(microsoft.public.sqlserver.setup)
Re: How to import one DB to another using any tool
... I understood that you were content with taking a copy of the database ... In that case BACKUP/RESTORE ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.programming)
Re: How to import one DB to another using any tool
... So honestly, I could find all this within 2 minutes and I haven't touched google yet, so I did. ... "Import ms sql server 2008" and guess what the VERY FIRST entry was? ... Importing and Exporting Data by Using SQL Server Import and Export Wizard. ... It's trivial when you already know the process, the backup/restore ...
(microsoft.public.sqlserver.programming)
Re: Remote synchronization
... I simply backup/restore or attach/detach... ... Wayne Snyder, MCDBA, SQL Server MVP ... Is there a way to have a copy this app on a laptop ...
(microsoft.public.sqlserver.server)