Migrating to a new server

I currently have SQL running on an server that used to be used for call
center operations. There are many orphaned applications on this server and
we are planning to back up the server, reinstall a freash copy of 2000 server
and SQL 2000.
I have seen there is several ways to migrate data back onto the server,
detach / attach, restore from back up's, etc...
Our data center who is responsible for the maintenance of the server uses a
tool called vertias to back up the SQL databases.
Can anyone tell me the best method of restoring the system?Hi Gary
Usually it will depend on how big the databases are as to how you plan this.
You don't say if you normally back your databases up to disc and then to tape
or use the plug-ins. You also don't say if you are going to reformat the
drives or not!
If you backup to disc then you can use those backups to restore the
databases, providing the drives have not been reformated! If you don't have
backups on disc you could backup to a networked machine or possibly a plugged
in device and then use them to restore from. Restoring from tape will be
possible, but it will probably take significantly longer. You should also
verify the backups (tape or disc) before you remove SQL Server. As an
alternative to backing up you could detach the user databases and re-attach
them, once you have re-installed SQL Server and service packed it (this may
be the quickest method) but having a backup on disc and/or tape will give
you a second/third level of recovery.
John
"GaryC" wrote:
> I currently have SQL running on an server that used to be used for call
> center operations. There are many orphaned applications on this server and
> we are planning to back up the server, reinstall a freash copy of 2000 server
> and SQL 2000.
> I have seen there is several ways to migrate data back onto the server,
> detach / attach, restore from back up's, etc...
> Our data center who is responsible for the maintenance of the server uses a
> tool called vertias to back up the SQL databases.
> Can anyone tell me the best method of restoring the system?|||Gary
http://vyaskn.tripod.com/moving_sql_server.htm
"GaryC" <GaryC@.discussions.microsoft.com> wrote in message
news:DDAE0D2D-B700-474B-95A8-4FC1D80FEFF8@.microsoft.com...
>I currently have SQL running on an server that used to be used for call
> center operations. There are many orphaned applications on this server
> and
> we are planning to back up the server, reinstall a freash copy of 2000
> server
> and SQL 2000.
> I have seen there is several ways to migrate data back onto the server,
> detach / attach, restore from back up's, etc...
> Our data center who is responsible for the maintenance of the server uses
> a
> tool called vertias to back up the SQL databases.
> Can anyone tell me the best method of restoring the system?|||Hi John
I have started with a new company and will be working from home. We did a
back up onto a memory stick of QuickBooks and I want to put the data onto my
QuickBooks at home. I have put the memory stick in but can't read any of the
data can you please tell me how I can do this?
Michelle
"John Bell" wrote:
> Hi Gary
> Usually it will depend on how big the databases are as to how you plan this.
> You don't say if you normally back your databases up to disc and then to tape
> or use the plug-ins. You also don't say if you are going to reformat the
> drives or not!
> If you backup to disc then you can use those backups to restore the
> databases, providing the drives have not been reformated! If you don't have
> backups on disc you could backup to a networked machine or possibly a plugged
> in device and then use them to restore from. Restoring from tape will be
> possible, but it will probably take significantly longer. You should also
> verify the backups (tape or disc) before you remove SQL Server. As an
> alternative to backing up you could detach the user databases and re-attach
> them, once you have re-installed SQL Server and service packed it (this may
> be the quickest method) but having a backup on disc and/or tape will give
> you a second/third level of recovery.
> John
> "GaryC" wrote:
> > I currently have SQL running on an server that used to be used for call
> > center operations. There are many orphaned applications on this server and
> > we are planning to back up the server, reinstall a freash copy of 2000 server
> > and SQL 2000.
> >
> > I have seen there is several ways to migrate data back onto the server,
> > detach / attach, restore from back up's, etc...
> >
> > Our data center who is responsible for the maintenance of the server uses a
> > tool called vertias to back up the SQL databases.
> >
> > Can anyone tell me the best method of restoring the system?|||This is probably the wrong newsgroup for help with Quickbooks or memory
stick issues. You may be better off posting to a Windows newsgroup, or even
checking with www.quickbooks.com for appropriate help forums.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Michelle" <Michelle@.discussions.microsoft.com> wrote in message
news:71DF43A3-8590-4466-9E6D-5B8052ACB8B4@.microsoft.com...
> Hi John
> I have started with a new company and will be working from home. We did a
> back up onto a memory stick of QuickBooks and I want to put the data onto
> my
> QuickBooks at home. I have put the memory stick in but can't read any of
> the
> data can you please tell me how I can do this?
> Michelle
> "John Bell" wrote:
>> Hi Gary
>> Usually it will depend on how big the databases are as to how you plan
>> this.
>> You don't say if you normally back your databases up to disc and then to
>> tape
>> or use the plug-ins. You also don't say if you are going to reformat the
>> drives or not!
>> If you backup to disc then you can use those backups to restore the
>> databases, providing the drives have not been reformated! If you don't
>> have
>> backups on disc you could backup to a networked machine or possibly a
>> plugged
>> in device and then use them to restore from. Restoring from tape will be
>> possible, but it will probably take significantly longer. You should also
>> verify the backups (tape or disc) before you remove SQL Server. As an
>> alternative to backing up you could detach the user databases and
>> re-attach
>> them, once you have re-installed SQL Server and service packed it (this
>> may
>> be the quickest method) but having a backup on disc and/or tape will
>> give
>> you a second/third level of recovery.
>> John
>> "GaryC" wrote:
>> > I currently have SQL running on an server that used to be used for call
>> > center operations. There are many orphaned applications on this server
>> > and
>> > we are planning to back up the server, reinstall a freash copy of 2000
>> > server
>> > and SQL 2000.
>> >
>> > I have seen there is several ways to migrate data back onto the server,
>> > detach / attach, restore from back up's, etc...
>> >
>> > Our data center who is responsible for the maintenance of the server
>> > uses a
>> > tool called vertias to back up the SQL databases.
>> >
>> > Can anyone tell me the best method of restoring the system?|||Hi Michelle
As Arnie has said Quickbooks is not really the forte of the people answering
the questions in these groups, but there may be some things you can try, such
as being able to browse the files on the memory stick with windows explorer.
If this is not possible or if you can see the device and not the files then
there is something wrong with either the device or the method you are using
to copy the files.
If you can see the files you require then you may want to copy them into a
directory on the PC. If the files have to be in a specific directory you may
have to move them there. Finding out what files are currently present in
Quickbooks may help you determine this. I would also backup the PC and the
existing Quickbooks setup before you start to do anything. You may want to
try using Quickbooks to create a new set of files and see what files change.
This may give you some indication of what files are needed.
I don't know if Quickbooks has a open file type of functionality or an
import facility, if it does then read up on these in the manual as it may
help.
HTH
John
"Michelle" wrote:
> Hi John
> I have started with a new company and will be working from home. We did a
> back up onto a memory stick of QuickBooks and I want to put the data onto my
> QuickBooks at home. I have put the memory stick in but can't read any of the
> data can you please tell me how I can do this?
> Michelle
> "John Bell" wrote:
> > Hi Gary
> >
> > Usually it will depend on how big the databases are as to how you plan this.
> > You don't say if you normally back your databases up to disc and then to tape
> > or use the plug-ins. You also don't say if you are going to reformat the
> > drives or not!
> >
> > If you backup to disc then you can use those backups to restore the
> > databases, providing the drives have not been reformated! If you don't have
> > backups on disc you could backup to a networked machine or possibly a plugged
> > in device and then use them to restore from. Restoring from tape will be
> > possible, but it will probably take significantly longer. You should also
> > verify the backups (tape or disc) before you remove SQL Server. As an
> > alternative to backing up you could detach the user databases and re-attach
> > them, once you have re-installed SQL Server and service packed it (this may
> > be the quickest method) but having a backup on disc and/or tape will give
> > you a second/third level of recovery.
> >
> > John
> >
> > "GaryC" wrote:
> >
> > > I currently have SQL running on an server that used to be used for call
> > > center operations. There are many orphaned applications on this server and
> > > we are planning to back up the server, reinstall a freash copy of 2000 server
> > > and SQL 2000.
> > >
> > > I have seen there is several ways to migrate data back onto the server,
> > > detach / attach, restore from back up's, etc...
> > >
> > > Our data center who is responsible for the maintenance of the server uses a
> > > tool called vertias to back up the SQL databases.
> > >
> > > Can anyone tell me the best method of restoring the system?