Problem recreating database

Had a crash and am trying to recreate my database. I have large files (200mb each)created using sql 7, a mdf and ldf file. When restoring on sql 2000 I get an internal consistency error trying to attach the mdf and ldf files. It fails half way through.

I desparetly need this database restored and would appreicate any help

Hi,

you could try to use the sp_attach_single_file_db and hope that this will be successfull. Seems that your database is inconsistent, do you have a valid backup ? That would be the best solution. Otherwise I hope for you that only attaching the MDF file with the above command works for you.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

sql

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work
.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in
.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in th
e
install.
Tony
"Uri Dimant" wrote:

> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run und
er
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.
Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>
|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:

> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:
> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
> >I tried to run the new SP2 and it crashes. I get the dialog asking to send
> > the crash data to microsoft.
> >
> > I then checked the upgrade log and found a message saying that it could
> > not
> > log into the server. I know it had the right password because the service
> > pack checks that near the begining.
> >
> > I then checked the service and noticed that is was stopped. I then tried
> > to
> > manually start and stop the service during the upgrade each time I saw
> > that
> > it needed to start or stop it by the messages that came up. That didn't
> > work.
> > It got to a point later that said it could not stop the service.
> >
> > I then changed the login of the services themselves to be tan admin user.
> > That seemed to allow the service pack to start and stop the service ok,
> > but
> > it still crashes near the end now. The message is again that it can't log
> > in.
> >
> > I also must mention that after the first time this happened the small icon
> > on the lower right of the tray that is the sql server is gone.
> >
> > Please help. I need to get the SP2 to succeed so that it will be back to
> > normal.
> >
>
>