Question: I have a few databases that were told to restore via a
script. They've been stuck in a 'Restoring...' state for two days now,
and I need to kill it.
What can I do from administration standpoint to stop this?
Thanks,
MichaelThe restore process is probably done by now, and the databases are left in t
he restoring state
(either because the restore process was terminated, or because you restore u
sing the NORECOVERY
option). If it is the later, try:
RESTORE DATABASE dbname WITH RECOVERY
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
news:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> Question: I have a few databases that were told to restore via a
> script. They've been stuck in a 'Restoring...' state for two days now,
> and I need to kill it.
> What can I do from administration standpoint to stop this?
> Thanks,
> Michael
>|||I believe it is the former - when I try and run "RESTORE DATABASE
trial75441 WITH RECOVERY", I receive the following:
Msg 4319, Level 16, State 3, Line 1
A previous restore operation was interrupted and did not complete
processing on file 'trial75441_log'. Either restore the backup set that
was interrupted or restart the restore sequence.
Is there a way to force this restore to terminate via a command? If
not, what command allows me to restart?
Again, I apologize for my ignorance. I've away from the Windows
sysadmin side for a couple of years, and am now getting back into it
heavily. By the way, is there a good book that you can recommend for
running SQL Server 2005?
On Nov 3, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> The restore process is probably done by now, and the databases are left in
the restoring state
> (either because the restore process was terminated, or because you restore
using the NORECOVERY
> option). If it is the later, try:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://www.solidqualitylearning.com/
> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in messagenews:1162563
793.422412.281130@.m73g2000cwd.googlegroups.com...
>
>
>
>|||Since the RESTORE process creates the database for you, the easiest way is p
robably to just DROP
DATABASE and then start the restore operation from scratch.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...
>I believe it is the former - when I try and run "RESTORE DATABASE
> trial75441 WITH RECOVERY", I receive the following:
> Msg 4319, Level 16, State 3, Line 1
> A previous restore operation was interrupted and did not complete
> processing on file 'trial75441_log'. Either restore the backup set that
> was interrupted or restart the restore sequence.
> Is there a way to force this restore to terminate via a command? If
> not, what command allows me to restart?
> Again, I apologize for my ignorance. I've away from the Windows
> sysadmin side for a couple of years, and am now getting back into it
> heavily. By the way, is there a good book that you can recommend for
> running SQL Server 2005?
> On Nov 3, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>|||I just had the same problem and doing what Tibor Karaszi mentioned
worked.
I dropped the databases that were created by the failed restore and
re-ran the restore script and it worked the 2nd time around.
Tibor Karaszi wrote:[vbcol=seagreen]
> Since the RESTORE process creates the database for you, the easiest way is
probably to just DROP
> DATABASE and then start the restore operation from scratch.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
> news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...|||Perfect guys. I did that, and I'm in good shape.
Thank you all for your help.
On Nov 3, 11:38 am, "Hulicat" <dennis_A_wh...@.yahoo.com> wrote:[vbcol=seagreen]
> I just had the same problem and doing what Tibor Karaszi mentioned
> worked.
> I dropped the databases that were created by the failed restore and
> re-ran the restore script and it worked the 2nd time around.
> Tibor Karaszi wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
Showing posts with label stuck. Show all posts
Showing posts with label stuck. Show all posts
Monday, March 26, 2012
How do I kill a restore?
Question: I have a few databases that were told to restore via a
script. They've been stuck in a 'Restoring...' state for two days now,
and I need to kill it.
What can I do from administration standpoint to stop this?
Thanks,
Michael
I believe it is the former - when I try and run "RESTORE DATABASE
trial75441 WITH RECOVERY", I receive the following:
Msg 4319, Level 16, State 3, Line 1
A previous restore operation was interrupted and did not complete
processing on file 'trial75441_log'. Either restore the backup set that
was interrupted or restart the restore sequence.
Is there a way to force this restore to terminate via a command? If
not, what command allows me to restart?
Again, I apologize for my ignorance. I've away from the Windows
sysadmin side for a couple of years, and am now getting back into it
heavily. By the way, is there a good book that you can recommend for
running SQL Server 2005?
On Nov 3, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> The restore process is probably done by now, and the databases are left in the restoring state
> (either because the restore process was terminated, or because you restore using the NORECOVERY
> option). If it is the later, try:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in messagenews:1162563793.422412.281130@.m73g2000cwd.g ooglegroups.com...
>
>
|||I just had the same problem and doing what Tibor Karaszi mentioned
worked.
I dropped the databases that were created by the failed restore and
re-ran the restore script and it worked the 2nd time around.
Tibor Karaszi wrote:[vbcol=seagreen]
> Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
> DATABASE and then start the restore operation from scratch.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
> news:1162567958.824002.311440@.k70g2000cwa.googlegr oups.com...
|||Perfect guys. I did that, and I'm in good shape.
Thank you all for your help.
On Nov 3, 11:38 am, "Hulicat" <dennis_A_wh...@.yahoo.com> wrote:[vbcol=seagreen]
> I just had the same problem and doing what Tibor Karaszi mentioned
> worked.
> I dropped the databases that were created by the failed restore and
> re-ran the restore script and it worked the 2nd time around.
> Tibor Karaszi wrote:
>
>
>
>
>
>
script. They've been stuck in a 'Restoring...' state for two days now,
and I need to kill it.
What can I do from administration standpoint to stop this?
Thanks,
Michael
I believe it is the former - when I try and run "RESTORE DATABASE
trial75441 WITH RECOVERY", I receive the following:
Msg 4319, Level 16, State 3, Line 1
A previous restore operation was interrupted and did not complete
processing on file 'trial75441_log'. Either restore the backup set that
was interrupted or restart the restore sequence.
Is there a way to force this restore to terminate via a command? If
not, what command allows me to restart?
Again, I apologize for my ignorance. I've away from the Windows
sysadmin side for a couple of years, and am now getting back into it
heavily. By the way, is there a good book that you can recommend for
running SQL Server 2005?
On Nov 3, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> The restore process is probably done by now, and the databases are left in the restoring state
> (either because the restore process was terminated, or because you restore using the NORECOVERY
> option). If it is the later, try:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in messagenews:1162563793.422412.281130@.m73g2000cwd.g ooglegroups.com...
>
>
|||I just had the same problem and doing what Tibor Karaszi mentioned
worked.
I dropped the databases that were created by the failed restore and
re-ran the restore script and it worked the 2nd time around.
Tibor Karaszi wrote:[vbcol=seagreen]
> Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
> DATABASE and then start the restore operation from scratch.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
> news:1162567958.824002.311440@.k70g2000cwa.googlegr oups.com...
|||Perfect guys. I did that, and I'm in good shape.
Thank you all for your help.
On Nov 3, 11:38 am, "Hulicat" <dennis_A_wh...@.yahoo.com> wrote:[vbcol=seagreen]
> I just had the same problem and doing what Tibor Karaszi mentioned
> worked.
> I dropped the databases that were created by the failed restore and
> re-ran the restore script and it worked the 2nd time around.
> Tibor Karaszi wrote:
>
>
>
>
>
>
How do I kill a restore?
Question: I have a few databases that were told to restore via a
script. They've been stuck in a 'Restoring...' state for two days now,
and I need to kill it.
What can I do from administration standpoint to stop this?
Thanks,
MichaelThe restore process is probably done by now, and the databases are left in the restoring state
(either because the restore process was terminated, or because you restore using the NORECOVERY
option). If it is the later, try:
RESTORE DATABASE dbname WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
news:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> Question: I have a few databases that were told to restore via a
> script. They've been stuck in a 'Restoring...' state for two days now,
> and I need to kill it.
> What can I do from administration standpoint to stop this?
> Thanks,
> Michael
>|||I believe it is the former - when I try and run "RESTORE DATABASE
trial75441 WITH RECOVERY", I receive the following:
Msg 4319, Level 16, State 3, Line 1
A previous restore operation was interrupted and did not complete
processing on file 'trial75441_log'. Either restore the backup set that
was interrupted or restart the restore sequence.
Is there a way to force this restore to terminate via a command? If
not, what command allows me to restart?
Again, I apologize for my ignorance. I've away from the Windows
sysadmin side for a couple of years, and am now getting back into it
heavily. By the way, is there a good book that you can recommend for
running SQL Server 2005?
On Nov 3, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> The restore process is probably done by now, and the databases are left in the restoring state
> (either because the restore process was terminated, or because you restore using the NORECOVERY
> option). If it is the later, try:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> > Question: I have a few databases that were told to restore via a
> > script. They've been stuck in a 'Restoring...' state for two days now,
> > and I need to kill it.
> > What can I do from administration standpoint to stop this?
> > Thanks,
> > Michael|||Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
DATABASE and then start the restore operation from scratch.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...
>I believe it is the former - when I try and run "RESTORE DATABASE
> trial75441 WITH RECOVERY", I receive the following:
> Msg 4319, Level 16, State 3, Line 1
> A previous restore operation was interrupted and did not complete
> processing on file 'trial75441_log'. Either restore the backup set that
> was interrupted or restart the restore sequence.
> Is there a way to force this restore to terminate via a command? If
> not, what command allows me to restart?
> Again, I apologize for my ignorance. I've away from the Windows
> sysadmin side for a couple of years, and am now getting back into it
> heavily. By the way, is there a good book that you can recommend for
> running SQL Server 2005?
> On Nov 3, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> The restore process is probably done by now, and the databases are left in the restoring state
>> (either because the restore process was terminated, or because you restore using the NORECOVERY
>> option). If it is the later, try:
>> RESTORE DATABASE dbname WITH RECOVERY
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
>> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in
>> messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
>> > Question: I have a few databases that were told to restore via a
>> > script. They've been stuck in a 'Restoring...' state for two days now,
>> > and I need to kill it.
>> > What can I do from administration standpoint to stop this?
>> > Thanks,
>> > Michael
>|||I just had the same problem and doing what Tibor Karaszi mentioned
worked.
I dropped the databases that were created by the failed restore and
re-ran the restore script and it worked the 2nd time around.
Tibor Karaszi wrote:
> Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
> DATABASE and then start the restore operation from scratch.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
> news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...
> >I believe it is the former - when I try and run "RESTORE DATABASE
> > trial75441 WITH RECOVERY", I receive the following:
> >
> > Msg 4319, Level 16, State 3, Line 1
> > A previous restore operation was interrupted and did not complete
> > processing on file 'trial75441_log'. Either restore the backup set that
> > was interrupted or restart the restore sequence.
> >
> > Is there a way to force this restore to terminate via a command? If
> > not, what command allows me to restart?
> >
> > Again, I apologize for my ignorance. I've away from the Windows
> > sysadmin side for a couple of years, and am now getting back into it
> > heavily. By the way, is there a good book that you can recommend for
> > running SQL Server 2005?
> >
> > On Nov 3, 9:58 am, "Tibor Karaszi"
> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> The restore process is probably done by now, and the databases are left in the restoring state
> >> (either because the restore process was terminated, or because you restore using the NORECOVERY
> >> option). If it is the later, try:
> >>
> >> RESTORE DATABASE dbname WITH RECOVERY
> >>
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> >>
> >> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in
> >> messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> >>
> >> > Question: I have a few databases that were told to restore via a
> >> > script. They've been stuck in a 'Restoring...' state for two days now,
> >> > and I need to kill it.
> >>
> >> > What can I do from administration standpoint to stop this?
> >>
> >> > Thanks,
> >>
> >> > Michael
> >|||Perfect guys. I did that, and I'm in good shape.
Thank you all for your help.
On Nov 3, 11:38 am, "Hulicat" <dennis_A_wh...@.yahoo.com> wrote:
> I just had the same problem and doing what Tibor Karaszi mentioned
> worked.
> I dropped the databases that were created by the failed restore and
> re-ran the restore script and it worked the 2nd time around.
> Tibor Karaszi wrote:
> > Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
> > DATABASE and then start the restore operation from scratch.
> > --
> > Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> > "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in message
> >news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...
> > >I believe it is the former - when I try and run "RESTORE DATABASE
> > > trial75441 WITH RECOVERY", I receive the following:
> > > Msg 4319, Level 16, State 3, Line 1
> > > A previous restore operation was interrupted and did not complete
> > > processing on file 'trial75441_log'. Either restore the backup set that
> > > was interrupted or restart the restore sequence.
> > > Is there a way to force this restore to terminate via a command? If
> > > not, what command allows me to restart?
> > > Again, I apologize for my ignorance. I've away from the Windows
> > > sysadmin side for a couple of years, and am now getting back into it
> > > heavily. By the way, is there a good book that you can recommend for
> > > running SQL Server 2005?
> > > On Nov 3, 9:58 am, "Tibor Karaszi"
> > > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > >> The restore process is probably done by now, and the databases are left in the restoring state
> > >> (either because the restore process was terminated, or because you restore using the NORECOVERY
> > >> option). If it is the later, try:
> > >> RESTORE DATABASE dbname WITH RECOVERY
> > >> --
> > >> Tibor Karaszi, SQL Server
> > >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualityle...
> > >> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in
> > >> messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> > >> > Question: I have a few databases that were told to restore via a
> > >> > script. They've been stuck in a 'Restoring...' state for two days now,
> > >> > and I need to kill it.
> > >> > What can I do from administration standpoint to stop this?
> > >> > Thanks,
> > >> > Michaelsql
script. They've been stuck in a 'Restoring...' state for two days now,
and I need to kill it.
What can I do from administration standpoint to stop this?
Thanks,
MichaelThe restore process is probably done by now, and the databases are left in the restoring state
(either because the restore process was terminated, or because you restore using the NORECOVERY
option). If it is the later, try:
RESTORE DATABASE dbname WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
news:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> Question: I have a few databases that were told to restore via a
> script. They've been stuck in a 'Restoring...' state for two days now,
> and I need to kill it.
> What can I do from administration standpoint to stop this?
> Thanks,
> Michael
>|||I believe it is the former - when I try and run "RESTORE DATABASE
trial75441 WITH RECOVERY", I receive the following:
Msg 4319, Level 16, State 3, Line 1
A previous restore operation was interrupted and did not complete
processing on file 'trial75441_log'. Either restore the backup set that
was interrupted or restart the restore sequence.
Is there a way to force this restore to terminate via a command? If
not, what command allows me to restart?
Again, I apologize for my ignorance. I've away from the Windows
sysadmin side for a couple of years, and am now getting back into it
heavily. By the way, is there a good book that you can recommend for
running SQL Server 2005?
On Nov 3, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> The restore process is probably done by now, and the databases are left in the restoring state
> (either because the restore process was terminated, or because you restore using the NORECOVERY
> option). If it is the later, try:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> > Question: I have a few databases that were told to restore via a
> > script. They've been stuck in a 'Restoring...' state for two days now,
> > and I need to kill it.
> > What can I do from administration standpoint to stop this?
> > Thanks,
> > Michael|||Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
DATABASE and then start the restore operation from scratch.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...
>I believe it is the former - when I try and run "RESTORE DATABASE
> trial75441 WITH RECOVERY", I receive the following:
> Msg 4319, Level 16, State 3, Line 1
> A previous restore operation was interrupted and did not complete
> processing on file 'trial75441_log'. Either restore the backup set that
> was interrupted or restart the restore sequence.
> Is there a way to force this restore to terminate via a command? If
> not, what command allows me to restart?
> Again, I apologize for my ignorance. I've away from the Windows
> sysadmin side for a couple of years, and am now getting back into it
> heavily. By the way, is there a good book that you can recommend for
> running SQL Server 2005?
> On Nov 3, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> The restore process is probably done by now, and the databases are left in the restoring state
>> (either because the restore process was terminated, or because you restore using the NORECOVERY
>> option). If it is the later, try:
>> RESTORE DATABASE dbname WITH RECOVERY
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
>> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in
>> messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
>> > Question: I have a few databases that were told to restore via a
>> > script. They've been stuck in a 'Restoring...' state for two days now,
>> > and I need to kill it.
>> > What can I do from administration standpoint to stop this?
>> > Thanks,
>> > Michael
>|||I just had the same problem and doing what Tibor Karaszi mentioned
worked.
I dropped the databases that were created by the failed restore and
re-ran the restore script and it worked the 2nd time around.
Tibor Karaszi wrote:
> Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
> DATABASE and then start the restore operation from scratch.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael Gorsuch" <michael.gorsuch@.gmail.com> wrote in message
> news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...
> >I believe it is the former - when I try and run "RESTORE DATABASE
> > trial75441 WITH RECOVERY", I receive the following:
> >
> > Msg 4319, Level 16, State 3, Line 1
> > A previous restore operation was interrupted and did not complete
> > processing on file 'trial75441_log'. Either restore the backup set that
> > was interrupted or restart the restore sequence.
> >
> > Is there a way to force this restore to terminate via a command? If
> > not, what command allows me to restart?
> >
> > Again, I apologize for my ignorance. I've away from the Windows
> > sysadmin side for a couple of years, and am now getting back into it
> > heavily. By the way, is there a good book that you can recommend for
> > running SQL Server 2005?
> >
> > On Nov 3, 9:58 am, "Tibor Karaszi"
> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> The restore process is probably done by now, and the databases are left in the restoring state
> >> (either because the restore process was terminated, or because you restore using the NORECOVERY
> >> option). If it is the later, try:
> >>
> >> RESTORE DATABASE dbname WITH RECOVERY
> >>
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> >>
> >> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in
> >> messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> >>
> >> > Question: I have a few databases that were told to restore via a
> >> > script. They've been stuck in a 'Restoring...' state for two days now,
> >> > and I need to kill it.
> >>
> >> > What can I do from administration standpoint to stop this?
> >>
> >> > Thanks,
> >>
> >> > Michael
> >|||Perfect guys. I did that, and I'm in good shape.
Thank you all for your help.
On Nov 3, 11:38 am, "Hulicat" <dennis_A_wh...@.yahoo.com> wrote:
> I just had the same problem and doing what Tibor Karaszi mentioned
> worked.
> I dropped the databases that were created by the failed restore and
> re-ran the restore script and it worked the 2nd time around.
> Tibor Karaszi wrote:
> > Since the RESTORE process creates the database for you, the easiest way is probably to just DROP
> > DATABASE and then start the restore operation from scratch.
> > --
> > Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> > "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in message
> >news:1162567958.824002.311440@.k70g2000cwa.googlegroups.com...
> > >I believe it is the former - when I try and run "RESTORE DATABASE
> > > trial75441 WITH RECOVERY", I receive the following:
> > > Msg 4319, Level 16, State 3, Line 1
> > > A previous restore operation was interrupted and did not complete
> > > processing on file 'trial75441_log'. Either restore the backup set that
> > > was interrupted or restart the restore sequence.
> > > Is there a way to force this restore to terminate via a command? If
> > > not, what command allows me to restart?
> > > Again, I apologize for my ignorance. I've away from the Windows
> > > sysadmin side for a couple of years, and am now getting back into it
> > > heavily. By the way, is there a good book that you can recommend for
> > > running SQL Server 2005?
> > > On Nov 3, 9:58 am, "Tibor Karaszi"
> > > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > >> The restore process is probably done by now, and the databases are left in the restoring state
> > >> (either because the restore process was terminated, or because you restore using the NORECOVERY
> > >> option). If it is the later, try:
> > >> RESTORE DATABASE dbname WITH RECOVERY
> > >> --
> > >> Tibor Karaszi, SQL Server
> > >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualityle...
> > >> "Michael Gorsuch" <michael.gors...@.gmail.com> wrote in
> > >> messagenews:1162563793.422412.281130@.m73g2000cwd.googlegroups.com...
> > >> > Question: I have a few databases that were told to restore via a
> > >> > script. They've been stuck in a 'Restoring...' state for two days now,
> > >> > and I need to kill it.
> > >> > What can I do from administration standpoint to stop this?
> > >> > Thanks,
> > >> > Michaelsql
Monday, March 19, 2012
How do I get my local data in the database on the Internet?
I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>
How do I get my local data in the database on the Internet?
I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.
Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>
|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?
|||Hi
May be look at replication?
http://msdn.microsoft.com/library/de...plsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.
Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>
|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?
|||Hi
May be look at replication?
http://msdn.microsoft.com/library/de...plsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>
How do I get my local data in the database on the Internet?
I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could us
e
FTP (possibly through a ASP component) to move your files to the location. I
f
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you wil
l
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/d...
ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could us
e
FTP (possibly through a ASP component) to move your files to the location. I
f
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you wil
l
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/d...
ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>
Subscribe to:
Posts (Atom)