Re: Need to recover DTS files from computer crash

From: Schoo (scott.schuman_at_nospam.ma-hc.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 11:36:50 -0600

Excellent! I will let the network admin know to restore that as well.
Thanks!

Scott

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:h59h60dttebdnn1genjn78fmq3nouq16nb@4ax.com...
> In terms of the DTS packagnes...if you saved your DTS
> packages to SQL Server then they will be in the msdb
> database. Once that is restored, you will have your
> packages.
>
> -Sue
>
> On Mon, 29 Mar 2004 15:11:14 -0600, "Schoo"
> <scott.schuman@nospam.ma-hc.com> wrote:
>
> >Our main SQL2000 server died over the weekend and the techs are in the
> >process of bringing another one online. I am a programmer being forced
to
> >act as DBA (because my employer is too cheap to get one) on this project.
> >The techs backed up the server so we have a backup to bring back the data
> >files and we are in the process of setting that up now. The problem is
that
> >we will be doing a fresh install and restoring the files to the drive and
> >then going into SQL to link to them. So, here are my questions:
> >
> >1) To bring up a new database file into SQL Server 2000 can I just use
the
> >wizards to do it, or do I need to create a new database with the same
> >filename as the file I am trying to install and then overwrite that file
> >with the real file from the backup?
> >2) How can I bring back my DTS packages? These are not part of database
> >files are they? How can I get them back?
> >
> >Any help you can offer would be great! Thanks,
> >
> >Scott
> >
>

Relevant Pages

  • Re: Creating a mirror image of a database
    ... using the WITH MOVE clause to RESTORE DATABASE ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > of using the values in the original database. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Database Transfer Problem
    ... The DTS package is very simple, it consists of one 'Copy SQL Server Objects' task. ... This task is set to drop all objects, recreate them, transfer the data and then restore all constraints and relationships. ... that there's no consistency to exactly which constraint ... I suspect that the problem is due to the fact that the database is being ...
    (microsoft.public.sqlserver.dts)
  • Re: Need to recover DTS files from computer crash
    ... In terms of the DTS packagnes...if you saved your DTS ... packages to SQL Server then they will be in the msdb ... >1) To bring up a new database file into SQL Server 2000 can I just use the ...
    (microsoft.public.sqlserver.server)
  • RE: How can We check the Relational check
    ... You can pass GVs between packages by either using the DTS object model ... "Krishna" wrote: ... > I have imported the tables from excel to my database which does not have the ...
    (microsoft.public.sqlserver.dts)
  • Re: How to read a text file really fast??
    ... > and store the data into an Access database. ... Note you can create and run DTS ... packages programatically. ... Now this helped me when using Access with a MSDE backend (I note you ...
    (microsoft.public.dotnet.languages.csharp)