RE: Recover SQL files & DST packages from server backup

Wow! Thanks. This looks like it will help a lot. I'll work on this and let
you know.

""Jenny wu [MSFT]"" wrote:

> Hi George,
>
> Thanks for posting here!
>
> I am sorry for the delayed response due to weekend. Please understand that
> the newsgroups are staffed weekdays by Microsoft Support professionals to
> answer your systems and applications questions. Your understanding is
> greatly appreciated!
>
> Yes, as you know the Eval SBS 2003 can not be upgrade to OEM SBS 2003 but
> it can be upgrade to RTM SBS. This is because the evaluation edition is a
> limited retail copy and it can only be upgraded to the full retail copy.
>
> You can export the settings of the evaluation SBS box and then import them
> after you install the OEM copy on the SBS box.
>
> Open ''Server Management''; navigate to ''Advanced Management''\''Migrate
> Server Settings''.
>
> Also, if you want to keep the messages on your original Exchange server,
> you can copy the Exchange metabase and log files, install the new box with
> the original domain name and organization name and then copy the metabase
> and log files to the newly installed OEM SBS.
> =============================
> I suggest that you follow the following KB article to restore or move
> database.
> 314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/?id=314546
>
> ================================
> In order to backup and restore the DTS Packages, it depends on how they are
> saved.
>
> 1. If the DTS Packages are saved to SQL Server, they would be saved in the
> sysdtspackages table in the SQL Server msdb database. So, backing up the
> MSDB database would also backup the DTS Packages.
>
> 2. If the DTS package is saved as a Structured Storage File, the DTS
> package is saved as a file with the extension .dts. This will be outside of
> SQL Server and you need to backup the *.dts files in order to backup such
> DTS Packages.
>
> The Database Maintenance Plans are also saved in the MSDB database. So
> backing up the MSDB database would also backup the Maintenance Plans.
>
> To move DTS packages, you may following these steps:
>
> If DTS packages are stored on the source server in the SQL Server or the
> repository,
>
> 1. Save the DTS package on the source server to a file, and then open the
> DTS package file on the destination server.
> 2. Save the package on the destination server to the SQL Server, or to the
> repository.NOTE: You have to move each package one by one in separate
> files.
>
> -or-
> 1. Open each DTS package in the DTS Designer.
> 2. On the Package menu, click Save As.
> 3. Specify the destination SQL Server.
> ======================================
> Hope this helps! If you have any further concern or question on the issue
> please feel free to let me know. I am happy to be assistance of you!
>
> Have a nice day!
>
> Best Regards,
>
> Jenny Wu
> Microsoft CSS Online Newsgroup Support
> Get Secure! - www.microsoft.com/security
> ======================================================
> This newsgroup only focuses on SBS technical issues. If you have issues
> regarding other Microsoft products, you'd better post in the corresponding
> newsgroups so that they can be resolved in an efficient and timely manner.
> You can locate the newsgroup here:
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check the
> "Notify me of replies" box to receive e-mail notifications when there are
> any updates in your thread. When responding to posts via your newsreader,
> please "Reply to Group" so that others may learn and benefit from your
> issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft CSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --------------------
> >Thread-Topic: Recover SQL files & DST packages from server backup
> >thread-index: AcW1U3z5C0FWjmZTTpCqlFYlq5dStQ==
> >X-WBNR-Posting-Host: 66.134.230.210
> >From: =?Utf-8?B?R2Vvcmdlbm5l?= <Georgenne@xxxxxxxxxxxxxxxxxxxxxxxxx>
> >Subject: Recover SQL files & DST packages from server backup
> >Date: Fri, 9 Sep 2005 08:31:03 -0700
> >Lines: 14
> >Message-ID: <8255E6F4-CA6E-4D21-A186-90B3D3DE631E@xxxxxxxxxxxxx>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.windows.server.sbs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:152061
> >X-Tomcat-NG: microsoft.public.windows.server.sbs
> >
> >1. We installed the evaluation copy of SBS 2003 and then purchased an OEM
> >version. Then we found out the OEM version wouldn't upgrade the eval copy.
> >2. We have now done a clean install with the OEM version. We have a
> >complete backup copy of the previous installation.
> >3. Is there a good way to restore the entire SQL data instance and files
> >from the back up to the new installation?
> >4. I know I can create a new instance on the new installation and attach
> the
> >databases individually.
> >5. Is there anyway to retreive the DTS local packages. I have many of
> them
> >and they save us lots of work. I would love to retreive them without
> having
> >to redesign them.
> >
> >I appreciate your help Thanks.
> >
> >
>
>
.

Relevant Pages

  • Re: SQL Server 2000 DTS Designer Components
    ... I actually have not installed the DTS Designer on the servers directly, but install it on client machines of programmers and administrators who manage the DTS packages. ... Having said that, I see that on my 64-bit server installation, the SQL Server Management Studio 2005, etc. are all x86 programs so the DTS Designer should work even there. ...
    (microsoft.public.sqlserver.clients)
  • Re: Very Very Urgent, Please Help
    ... does your packages are stored in the MSDB database? ... Have you changed your main package to use the right SQL Server instance? ... When my main dts package calls other dts packages getting timeout immediately. ...
    (microsoft.public.sqlserver.datawarehouse)
  • guest user in msdb
    ... dts packages and i donīt want that this users have ... permissions to create it. ... in the msdb database. ... if i this change can cause problems in sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server tables to Oracle
    ... You can use DTS packages from within SQL Server. ... The only thing you need to do is install the Oracle client libraries on the SQL Server box and define a connection to the Oracle instance. ...
    (comp.databases.oracle.server)
  • Re: Cannot See DTS Package Created
    ... What rights do you have in msdb database? ... > DTS packages but cannot see them in the SQL Server 2000 Enterprise ... After the new registered SQL Server with Windows only I ...
    (microsoft.public.sqlserver.dts)