RE: Recover SQL files & DST packages from server backup
- From: v-yanniw@xxxxxxxxxxxxxxxxxxxx ("Jenny wu [MSFT]")
- Date: Mon, 12 Sep 2005 06:43:27 GMT
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.
>
>
.
- Follow-Ups:
- RE: Recover SQL files & DST packages from server backup
- From: Georgenne
- RE: Recover SQL files & DST packages from server backup
- References:
- Recover SQL files & DST packages from server backup
- From: Georgenne
- Recover SQL files & DST packages from server backup
- Prev by Date: Re: Shadow Copies Directory Relocation
- Next by Date: RE: POP3 errors - thousands of them
- Previous by thread: Recover SQL files & DST packages from server backup
- Next by thread: RE: Recover SQL files & DST packages from server backup
- Index(es):
Relevant Pages
|
