need to backup databases and reinstall

I need to backup all my databases and reinstall sql 2000 on the same box. I
cannot open em. what do i need to do to backup all the databases and users
and restore it to a new install?Hi
If you removed SQL Server and then re-installed it will not remove the
database files, so you should be able to re-attach them after you have
reinstalled SQL Server and applied the appropriate Service Pack/hotfixes. If
you do re-install the system databases will be overwritten, which means that
you would loose any jobs, logins etc
Have you tried to connect using Enterprise Manager on a different machine?
Have you tried to connect using osql or query analyser? The format of the
BACKUP command and examples can be found in Books Online.
BACKUP DATABASE Master
TO DISK = 'C:\Backups\Master.Bak'
Also see http://support.microsoft.com/kb/304692/ on how to restore the
databases.
John
"nobody" wrote:
> I need to backup all my databases and reinstall sql 2000 on the same box. I
> cannot open em. what do i need to do to backup all the databases and users
> and restore it to a new install?
>
>|||what about user logsins? how do I save those? I cannot run em from another
machine as this machine will not start sql. from a failed backup
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A8373F81-E5D8-4A59-BFAB-C021B69BDF2E@.microsoft.com...
> Hi
> If you removed SQL Server and then re-installed it will not remove the
> database files, so you should be able to re-attach them after you have
> reinstalled SQL Server and applied the appropriate Service Pack/hotfixes.
> If
> you do re-install the system databases will be overwritten, which means
> that
> you would loose any jobs, logins etc
> Have you tried to connect using Enterprise Manager on a different machine?
> Have you tried to connect using osql or query analyser? The format of the
> BACKUP command and examples can be found in Books Online.
> BACKUP DATABASE Master
> TO DISK = 'C:\Backups\Master.Bak'
> Also see http://support.microsoft.com/kb/304692/ on how to restore the
> databases.
> John
> "nobody" wrote:
>> I need to backup all my databases and reinstall sql 2000 on the same box.
>> I
>> cannot open em. what do i need to do to backup all the databases and
>> users
>> and restore it to a new install?
>>|||Hi
If you restore master then the logins will be ok. I assume there is no
machine or domain change name? You can use
http://support.microsoft.com/kb/246133/ to script them
You may want to try using sp_detach/sp_attach for all databases
attach http://support.microsoft.com/default.aspx/kb/224071
John
"nobody" wrote:
> what about user logsins? how do I save those? I cannot run em from another
> machine as this machine will not start sql. from a failed backup
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:A8373F81-E5D8-4A59-BFAB-C021B69BDF2E@.microsoft.com...
> > Hi
> >
> > If you removed SQL Server and then re-installed it will not remove the
> > database files, so you should be able to re-attach them after you have
> > reinstalled SQL Server and applied the appropriate Service Pack/hotfixes.
> > If
> > you do re-install the system databases will be overwritten, which means
> > that
> > you would loose any jobs, logins etc
> >
> > Have you tried to connect using Enterprise Manager on a different machine?
> > Have you tried to connect using osql or query analyser? The format of the
> > BACKUP command and examples can be found in Books Online.
> >
> > BACKUP DATABASE Master
> > TO DISK = 'C:\Backups\Master.Bak'
> >
> > Also see http://support.microsoft.com/kb/304692/ on how to restore the
> > databases.
> >
> > John
> >
> > "nobody" wrote:
> >
> >> I need to backup all my databases and reinstall sql 2000 on the same box.
> >> I
> >> cannot open em. what do i need to do to backup all the databases and
> >> users
> >> and restore it to a new install?
> >>
> >>
> >>
>
>|||what do you think of this method
1. copy the data folder with all the databses put it somewhere.
2. add/remove sql server and remove it
3. reboot server
4 reinstall sql 2000 server + latest sp
5. go to em, and attach the databases one by one
will this do it?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:81E92BCB-8998-4A84-8A61-0C355768F9FE@.microsoft.com...
> Hi
> If you restore master then the logins will be ok. I assume there is no
> machine or domain change name? You can use
> http://support.microsoft.com/kb/246133/ to script them
> You may want to try using sp_detach/sp_attach for all databases
> attach http://support.microsoft.com/default.aspx/kb/224071
> John
> "nobody" wrote:
>> what about user logsins? how do I save those? I cannot run em from
>> another
>> machine as this machine will not start sql. from a failed backup
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:A8373F81-E5D8-4A59-BFAB-C021B69BDF2E@.microsoft.com...
>> > Hi
>> >
>> > If you removed SQL Server and then re-installed it will not remove the
>> > database files, so you should be able to re-attach them after you have
>> > reinstalled SQL Server and applied the appropriate Service
>> > Pack/hotfixes.
>> > If
>> > you do re-install the system databases will be overwritten, which means
>> > that
>> > you would loose any jobs, logins etc
>> >
>> > Have you tried to connect using Enterprise Manager on a different
>> > machine?
>> > Have you tried to connect using osql or query analyser? The format of
>> > the
>> > BACKUP command and examples can be found in Books Online.
>> >
>> > BACKUP DATABASE Master
>> > TO DISK = 'C:\Backups\Master.Bak'
>> >
>> > Also see http://support.microsoft.com/kb/304692/ on how to restore the
>> > databases.
>> >
>> > John
>> >
>> > "nobody" wrote:
>> >
>> >> I need to backup all my databases and reinstall sql 2000 on the same
>> >> box.
>> >> I
>> >> cannot open em. what do i need to do to backup all the databases and
>> >> users
>> >> and restore it to a new install?
>> >>
>> >>
>> >>
>>|||Hi
You will not be able to copy the databases whilst SQL Server is running
unless they are detatched, which certainly wont be for master msdb etc so you
need to stop SQL Server first. I hope you have enough space to store a
complete copy!!
For step 5 follow the link I provided in the previous post. You may need to
change the database owner if you attach them as a different user.
John
"nobody" wrote:
> what do you think of this method
> 1. copy the data folder with all the databses put it somewhere.
> 2. add/remove sql server and remove it
> 3. reboot server
> 4 reinstall sql 2000 server + latest sp
> 5. go to em, and attach the databases one by one
>
> will this do it?
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:81E92BCB-8998-4A84-8A61-0C355768F9FE@.microsoft.com...
> > Hi
> >
> > If you restore master then the logins will be ok. I assume there is no
> > machine or domain change name? You can use
> > http://support.microsoft.com/kb/246133/ to script them
> >
> > You may want to try using sp_detach/sp_attach for all databases
> > attach http://support.microsoft.com/default.aspx/kb/224071
> >
> > John
> >
> > "nobody" wrote:
> >
> >> what about user logsins? how do I save those? I cannot run em from
> >> another
> >> machine as this machine will not start sql. from a failed backup
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:A8373F81-E5D8-4A59-BFAB-C021B69BDF2E@.microsoft.com...
> >> > Hi
> >> >
> >> > If you removed SQL Server and then re-installed it will not remove the
> >> > database files, so you should be able to re-attach them after you have
> >> > reinstalled SQL Server and applied the appropriate Service
> >> > Pack/hotfixes.
> >> > If
> >> > you do re-install the system databases will be overwritten, which means
> >> > that
> >> > you would loose any jobs, logins etc
> >> >
> >> > Have you tried to connect using Enterprise Manager on a different
> >> > machine?
> >> > Have you tried to connect using osql or query analyser? The format of
> >> > the
> >> > BACKUP command and examples can be found in Books Online.
> >> >
> >> > BACKUP DATABASE Master
> >> > TO DISK = 'C:\Backups\Master.Bak'
> >> >
> >> > Also see http://support.microsoft.com/kb/304692/ on how to restore the
> >> > databases.
> >> >
> >> > John
> >> >
> >> > "nobody" wrote:
> >> >
> >> >> I need to backup all my databases and reinstall sql 2000 on the same
> >> >> box.
> >> >> I
> >> >> cannot open em. what do i need to do to backup all the databases and
> >> >> users
> >> >> and restore it to a new install?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>