restore problem  
Author Message
jonhyland





PostPosted: Wed Aug 11 11:59:03 CDT 2004 Top

SQL Server >> restore problem

Hi
i started a restore on a little db, it is still running (more than 15 mins),
how can i understand what is it doing???
Carlo

--

SQL Server186  
 
 
Keith





PostPosted: Wed Aug 11 11:59:03 CDT 2004 Top

SQL Server >> restore problem How little is the database?
In the future you can use the WITH STATS option to show you the percent
complete.

I am guessing that the SQL Server's disks are busy creating the database
files that will hold the data.

--
Keith




> Hi
> i started a restore on a little db, it is still running (more than 15
mins),
> how can i understand what is it doing???
> Carlo
>
> --
>
>
>

 
 
Carlo





PostPosted: Wed Aug 11 12:12:32 CDT 2004 Top

SQL Server >> restore problem the size of db is around 9 mb, it is a test db, it is still loading, how can
i stop the restore??


 
 
Richard





PostPosted: Wed Aug 11 13:39:05 CDT 2004 Top

SQL Server >> restore problem Are you able to see the new data/log files created in OS?
Also check to see if there's blocks.



> the size of db is around 9 mb, it is a test db, it is still loading, how
can
> i stop the restore??
>
>


 
 
Keith





PostPosted: Wed Aug 11 13:41:07 CDT 2004 Top

SQL Server >> restore problem 9MB. That is darn small. It has not finished yet? 22 minutes have gone by
since your original post and your second post. That is a too long to wait
for a 9MB database.

What did you use to begin the restore? Query Analyzer? Enterprise Manager?
Perhaps you could try closing the app. You could also kill that specific
connection, but that would be harsh.

--
Keith




> the size of db is around 9 mb, it is a test db, it is still loading, how
can
> i stop the restore??
>
>

 
 
Carlo





PostPosted: Wed Aug 11 14:36:01 CDT 2004 Top

SQL Server >> restore problem i stop the service and start it again, the db is alwais loading, i found in
the log this message:

Bypassing recovery for database 'db_rsnd' because it is marked IN LOAD.

what have i to do????
i'd like to know if i can delete the db from the server, but i cant do it
from the manager because it is loading and i suppose i cant delete it from
the console too. is there a way to delete the "row" in the master db that
let it know that my db exists??? i hope you understand what i mean.
Carlo

--



********************************************
Carlo Marcocci

Istituto Nazionale di Geofisica e Vulcanologia
Via di Vigna Murata 605, 00143 Roma
Tel. +39-6-51860391
Fax. +39-6-51860507

******************************************** L&P



> 9MB. That is darn small. It has not finished yet? 22 minutes have gone
by
> since your original post and your second post. That is a too long to wait
> for a 9MB database.
>
> What did you use to begin the restore? Query Analyzer? Enterprise
Manager?
> Perhaps you could try closing the app. You could also kill that specific
> connection, but that would be harsh.
>
> --
> Keith
>
>


> > the size of db is around 9 mb, it is a test db, it is still loading, how
> can
> > i stop the restore??
> >
> >
>


 
 
Carlo





PostPosted: Wed Aug 11 14:55:08 CDT 2004 Top

SQL Server >> restore problem
may i use this ????

UPDATE sysdatabases
SET status=16
WHERE name='daCancellare'

does it change anything????



--



********************************************
Carlo Marcocci

Istituto Nazionale di Geofisica e Vulcanologia
Via di Vigna Murata 605, 00143 Roma
Tel. +39-6-51860391
Fax. +39-6-51860507

******************************************** L&P



> 9MB. That is darn small. It has not finished yet? 22 minutes have gone
by
> since your original post and your second post. That is a too long to wait
> for a 9MB database.
>
> What did you use to begin the restore? Query Analyzer? Enterprise
Manager?
> Perhaps you could try closing the app. You could also kill that specific
> connection, but that would be harsh.
>
> --
> Keith
>
>


> > the size of db is around 9 mb, it is a test db, it is still loading, how
> can
> > i stop the restore??
> >
> >
>


 
 
Keith





PostPosted: Wed Aug 11 15:22:38 CDT 2004 Top

SQL Server >> restore problem I would try using DROP DATABASE
Information within Books Online (within the SQL Server program group).

--
Keith




>
> may i use this ????
>
> UPDATE sysdatabases
> SET status=16
> WHERE name='daCancellare'
>
> does it change anything????
>
>
>
> --
>
>
>
> ********************************************
> Carlo Marcocci
>
> Istituto Nazionale di Geofisica e Vulcanologia
> Via di Vigna Murata 605, 00143 Roma
> Tel. +39-6-51860391
> Fax. +39-6-51860507

> ******************************************** L&P
>


> > 9MB. That is darn small. It has not finished yet? 22 minutes have
gone
> by
> > since your original post and your second post. That is a too long to
wait
> > for a 9MB database.
> >
> > What did you use to begin the restore? Query Analyzer? Enterprise
> Manager?
> > Perhaps you could try closing the app. You could also kill that
specific
> > connection, but that would be harsh.
> >
> > --
> > Keith
> >
> >


> > > the size of db is around 9 mb, it is a test db, it is still loading,
how
> > can
> > > i stop the restore??
> > >
> > >
> >
>
>

 
 
Keith





PostPosted: Wed Aug 11 15:23:10 CDT 2004 Top

SQL Server >> restore problem Read up on DROP DATABASE within Books Online (within the SQL Server program
group).

--
Keith




> i stop the service and start it again, the db is alwais loading, i found
in
> the log this message:
>
> Bypassing recovery for database 'db_rsnd' because it is marked IN LOAD.
>
> what have i to do????
> i'd like to know if i can delete the db from the server, but i cant do it
> from the manager because it is loading and i suppose i cant delete it from
> the console too. is there a way to delete the "row" in the master db that
> let it know that my db exists??? i hope you understand what i mean.
> Carlo
>
> --
>
>
>
> ********************************************
> Carlo Marcocci
>
> Istituto Nazionale di Geofisica e Vulcanologia
> Via di Vigna Murata 605, 00143 Roma
> Tel. +39-6-51860391
> Fax. +39-6-51860507

> ******************************************** L&P
>


> > 9MB. That is darn small. It has not finished yet? 22 minutes have
gone
> by
> > since your original post and your second post. That is a too long to
wait
> > for a 9MB database.
> >
> > What did you use to begin the restore? Query Analyzer? Enterprise
> Manager?
> > Perhaps you could try closing the app. You could also kill that
specific
> > connection, but that would be harsh.
> >
> > --
> > Keith
> >
> >


> > > the size of db is around 9 mb, it is a test db, it is still loading,
how
> > can
> > > i stop the restore??
> > >
> > >
> >
>
>

 
 
hmh





PostPosted: Mon Aug 16 03:44:53 CDT 2004 Top

SQL Server >> restore problem By now you have fixed your problem. Some added thoughts.

I had a similar issue running SQL Server on a small PC that runs 24x7 (far
too little memory). There were times when a process that normally took 15
minutes ran for more than 3 hours.

1. Sometimes a reboot would speed up the process. Evidently, SQL Server
would grow and grow far beyond the physical memory. The PC spent all its
time paging memory in and out. There is a property to prevent this and set
the maximum memory that SQL Server can use.

2. I also had to set logging to a simple type rather than the full logging.
This is not a production database and we perform daily backups since it is
small. Simple logging is all that is required. With full logging, my tiny
databases (under 50 MB) grew to almost a gigabyte.

3. Wrote a stored procedure that runs in the SQL Server job scheduler every
night that performs a reindex on every table, then gets rid of the log ,
then shrinks the database. Issue has pretty much gone away.



> Hi
> i started a restore on a little db, it is still running (more than 15
mins),
> how can i understand what is it doing???
> Carlo
>
> --
>
>
>