|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Still Restoring...
I had problems trying to restore a database. I finally got the restore to run
with "NORECOVERY" That was two days ago and, the server management studio still shows the database with a green up arrow and the words (restoring...) after the database. It never came backup. I have even rebooted the server. Any ideas? Thanks, steve You can request an immedate recovery to get the database out of restoring
status using the special format of the RESTORE command: RESTORE DATABASE MyDatabase WITH RECOVERY; Note that this does not actually perform a restore (no FROM clause); uncommitted transactions are rolled back to complete the recovery process. Show quoteHide quote "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> wrote in message news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... >I had problems trying to restore a database. I finally got the restore to >run > with "NORECOVERY" > > That was two days ago and, the server management studio still shows the > database with a green up arrow and the words (restoring...) after the > database. It never came backup. I have even rebooted the server. > > Any ideas? > > Thanks, > steve Thanks Dan, I'll give it a try
Show quoteHide quote "Dan Guzman" wrote: > You can request an immedate recovery to get the database out of restoring > status using the special format of the RESTORE command: > > RESTORE DATABASE MyDatabase WITH RECOVERY; > > Note that this does not actually perform a restore (no FROM clause); > uncommitted transactions are rolled back to complete the recovery process. > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > http://weblogs.sqlteam.com/dang/ > > "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> > wrote in message news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... > >I had problems trying to restore a database. I finally got the restore to > >run > > with "NORECOVERY" > > > > That was two days ago and, the server management studio still shows the > > database with a green up arrow and the words (restoring...) after the > > database. It never came backup. I have even rebooted the server. > > > > Any ideas? > > > > Thanks, > > steve > > You do know that when you specified NORECOVERY, you told the database to
wait for DIFF backups and/or TLOG backups to be restored also, correct? If you have none of those to apply, then Dan's response is the correct one. How big is the db? -- Show quoteHide quoteKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. Twitter: Kevin3NF "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> wrote in message news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... >I had problems trying to restore a database. I finally got the restore to >run > with "NORECOVERY" > > That was two days ago and, the server management studio still shows the > database with a green up arrow and the words (restoring...) after the > database. It never came backup. I have even rebooted the server. > > Any ideas? > > Thanks, > steve No - I didnt realize that.
I just tried to run the command "RESTORE DATABASE WSS_Content_cws-docs WITH RECOVERY;" and received Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '-'. Msg 319, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Show quoteHide quote "Kevin3NF" wrote: > You do know that when you specified NORECOVERY, you told the database to > wait for DIFF backups and/or TLOG backups to be restored also, correct? If > you have none of those to apply, then Dan's response is the correct one. > > How big is the db? > > -- > > Kevin3NF > SQL Server dude > > You want fries with that? > http://kevin3nf.blogspot.com/ > > I only check the newsgroups during work hours, M-F. > Hit my blog and the contact links if necessary...I may be available. > > Twitter: Kevin3NF > > "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> > wrote in message news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... > >I had problems trying to restore a database. I finally got the restore to > >run > > with "NORECOVERY" > > > > That was two days ago and, the server management studio still shows the > > database with a green up arrow and the words (restoring...) after the > > database. It never came backup. I have even rebooted the server. > > > > Any ideas? > > > > Thanks, > > steve > > > I'm guessing that SQL is having an issue with the dash in the file name.
Try: RESTORE DATABASE [WSS_Content_cws-docs] WITH RECOVERY; If that doesn't work: Use master go DBCC DBRcover (WSS_Content_cws-docs) "Recovery" is the process SQL Server goes through to roll forward or rollback transactions and make a database usable. NORECOVERY says "don't do that, I'm not ready to use it..." -- Show quoteHide quoteKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. Twitter: Kevin3NF "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> wrote in message news:12A1662B-A11E-4623-8D78-9CA7934F5209@microsoft.com... > > No - I didnt realize that. > > I just tried to run the command "RESTORE DATABASE WSS_Content_cws-docs > WITH > RECOVERY;" > > and received > > Msg 102, Level 15, State 1, Line 2 > Incorrect syntax near '-'. > Msg 319, Level 15, State 1, Line 2 > Incorrect syntax near the keyword 'with'. If this statement is a common > table expression or an xmlnamespaces clause, the previous statement must > be > terminated with a semicolon. > > "Kevin3NF" wrote: > >> You do know that when you specified NORECOVERY, you told the database to >> wait for DIFF backups and/or TLOG backups to be restored also, correct? >> If >> you have none of those to apply, then Dan's response is the correct one. >> >> How big is the db? >> >> -- >> >> Kevin3NF >> SQL Server dude >> >> You want fries with that? >> http://kevin3nf.blogspot.com/ >> >> I only check the newsgroups during work hours, M-F. >> Hit my blog and the contact links if necessary...I may be available. >> >> Twitter: Kevin3NF >> >> "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> >> wrote in message >> news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... >> >I had problems trying to restore a database. I finally got the restore >> >to >> >run >> > with "NORECOVERY" >> > >> > That was two days ago and, the server management studio still shows the >> > database with a green up arrow and the words (restoring...) after the >> > database. It never came backup. I have even rebooted the server. >> > >> > Any ideas? >> > >> > Thanks, >> > steve >> >> >> Kevin - Your a genius!
RESTORE DATABASE [WSS_Content_cws-docs] WITH RECOVERY; Worked!! Many Thanks. I really appreciate it!! Show quoteHide quote "Kevin3NF" wrote: > I'm guessing that SQL is having an issue with the dash in the file name. > > Try: > > RESTORE DATABASE [WSS_Content_cws-docs] WITH > RECOVERY; > > If that doesn't work: > > Use master > go > DBCC DBRcover (WSS_Content_cws-docs) > > > > > "Recovery" is the process SQL Server goes through to roll forward or > rollback transactions and make a database usable. NORECOVERY says "don't do > that, I'm not ready to use it..." > -- > > Kevin3NF > SQL Server dude > > You want fries with that? > http://kevin3nf.blogspot.com/ > > I only check the newsgroups during work hours, M-F. > Hit my blog and the contact links if necessary...I may be available. > > Twitter: Kevin3NF > > "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> > wrote in message news:12A1662B-A11E-4623-8D78-9CA7934F5209@microsoft.com... > > > > No - I didnt realize that. > > > > I just tried to run the command "RESTORE DATABASE WSS_Content_cws-docs > > WITH > > RECOVERY;" > > > > and received > > > > Msg 102, Level 15, State 1, Line 2 > > Incorrect syntax near '-'. > > Msg 319, Level 15, State 1, Line 2 > > Incorrect syntax near the keyword 'with'. If this statement is a common > > table expression or an xmlnamespaces clause, the previous statement must > > be > > terminated with a semicolon. > > > > "Kevin3NF" wrote: > > > >> You do know that when you specified NORECOVERY, you told the database to > >> wait for DIFF backups and/or TLOG backups to be restored also, correct? > >> If > >> you have none of those to apply, then Dan's response is the correct one. > >> > >> How big is the db? > >> > >> -- > >> > >> Kevin3NF > >> SQL Server dude > >> > >> You want fries with that? > >> http://kevin3nf.blogspot.com/ > >> > >> I only check the newsgroups during work hours, M-F. > >> Hit my blog and the contact links if necessary...I may be available. > >> > >> Twitter: Kevin3NF > >> > >> "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> > >> wrote in message > >> news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... > >> >I had problems trying to restore a database. I finally got the restore > >> >to > >> >run > >> > with "NORECOVERY" > >> > > >> > That was two days ago and, the server management studio still shows the > >> > database with a green up arrow and the words (restoring...) after the > >> > database. It never came backup. I have even rebooted the server. > >> > > >> > Any ideas? > >> > > >> > Thanks, > >> > steve > >> > >> > >> > > > Cool...please send $1 to the charity of your choice ;)
-- Show quoteHide quoteKevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. Twitter: Kevin3NF "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> wrote in message news:FA822C6B-2395-49F3-ACA1-0C574FD4339A@microsoft.com... > Kevin - Your a genius! > > RESTORE DATABASE [WSS_Content_cws-docs] WITH > RECOVERY; > > Worked!! > > Many Thanks. I really appreciate it!! > > > "Kevin3NF" wrote: > >> I'm guessing that SQL is having an issue with the dash in the file name. >> >> Try: >> >> RESTORE DATABASE [WSS_Content_cws-docs] WITH >> RECOVERY; >> >> If that doesn't work: >> >> Use master >> go >> DBCC DBRcover (WSS_Content_cws-docs) >> >> >> >> >> "Recovery" is the process SQL Server goes through to roll forward or >> rollback transactions and make a database usable. NORECOVERY says "don't >> do >> that, I'm not ready to use it..." >> -- >> >> Kevin3NF >> SQL Server dude >> >> You want fries with that? >> http://kevin3nf.blogspot.com/ >> >> I only check the newsgroups during work hours, M-F. >> Hit my blog and the contact links if necessary...I may be available. >> >> Twitter: Kevin3NF >> >> "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> >> wrote in message >> news:12A1662B-A11E-4623-8D78-9CA7934F5209@microsoft.com... >> > >> > No - I didnt realize that. >> > >> > I just tried to run the command "RESTORE DATABASE WSS_Content_cws-docs >> > WITH >> > RECOVERY;" >> > >> > and received >> > >> > Msg 102, Level 15, State 1, Line 2 >> > Incorrect syntax near '-'. >> > Msg 319, Level 15, State 1, Line 2 >> > Incorrect syntax near the keyword 'with'. If this statement is a common >> > table expression or an xmlnamespaces clause, the previous statement >> > must >> > be >> > terminated with a semicolon. >> > >> > "Kevin3NF" wrote: >> > >> >> You do know that when you specified NORECOVERY, you told the database >> >> to >> >> wait for DIFF backups and/or TLOG backups to be restored also, >> >> correct? >> >> If >> >> you have none of those to apply, then Dan's response is the correct >> >> one. >> >> >> >> How big is the db? >> >> >> >> -- >> >> >> >> Kevin3NF >> >> SQL Server dude >> >> >> >> You want fries with that? >> >> http://kevin3nf.blogspot.com/ >> >> >> >> I only check the newsgroups during work hours, M-F. >> >> Hit my blog and the contact links if necessary...I may be available. >> >> >> >> Twitter: Kevin3NF >> >> >> >> "st***@mcmillaninc.com" >> >> <stevemcmillaninc***@discussions.microsoft.com> >> >> wrote in message >> >> news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... >> >> >I had problems trying to restore a database. I finally got the >> >> >restore >> >> >to >> >> >run >> >> > with "NORECOVERY" >> >> > >> >> > That was two days ago and, the server management studio still shows >> >> > the >> >> > database with a green up arrow and the words (restoring...) after >> >> > the >> >> > database. It never came backup. I have even rebooted the server. >> >> > >> >> > Any ideas? >> >> > >> >> > Thanks, >> >> > steve >> >> >> >> >> >> >> >> >> Database is only 13MB
Show quoteHide quote "Kevin3NF" wrote: > You do know that when you specified NORECOVERY, you told the database to > wait for DIFF backups and/or TLOG backups to be restored also, correct? If > you have none of those to apply, then Dan's response is the correct one. > > How big is the db? > > -- > > Kevin3NF > SQL Server dude > > You want fries with that? > http://kevin3nf.blogspot.com/ > > I only check the newsgroups during work hours, M-F. > Hit my blog and the contact links if necessary...I may be available. > > Twitter: Kevin3NF > > "st***@mcmillaninc.com" <stevemcmillaninc***@discussions.microsoft.com> > wrote in message news:17BFD822-DB8C-4668-8746-0893C094D0D5@microsoft.com... > >I had problems trying to restore a database. I finally got the restore to > >run > > with "NORECOVERY" > > > > That was two days ago and, the server management studio still shows the > > database with a green up arrow and the words (restoring...) after the > > database. It never came backup. I have even rebooted the server. > > > > Any ideas? > > > > Thanks, > > steve > > >  
Other interesting topics
Backup multi database
bak file = 5gb, attempted restore claims its 100Gb Backup and restore database to another server Big deletion is filling transaction log SSMS Open Table Include Column Headers LogFile size - general information SQL Server 2005 Performance Large table maintenance using DATEADD to report informaiton from 60 days ago Query timeout |
|||||||||||||||||||||||
