Recovery problem

In my production database i have lost data in three tables.so i just want to restore the data from my backup which was created.

I am connecting over remote desktop connetion to the server.

With in the databases i right click the database which has my three tables within them.

Then select all tasks->restore database

In restore i select files or file groups

then i select the day i want to restore the ok

It comes up with this error

Cannot open the back up device 'C:\programs\......'

device error or device online

Restore database is terminating abnormally

Is it because i am not doing at the server as i am connecting over remote desktop....

And my database has several tables apart from these three tables.is it possible for me just to restore these three tables.

i am using sql server 2000 database

Please let me know..

Are you using the GUI on the remote server or the GUI on your local machine? The GUI you use will need to be on the machine that the file resides if you are using localfile paths.

Also, you will only be able to restore those 3 tables using a PARTIAL restore if they exist in a separate filegroup to the rest of the data.If you only have one filegroup then you will have to restore the whole thing.

Either way, i think your only option is to do the restore to a separate database and then copy the data to your "live" db.

Check out the RESTORE information in Books Online as this gives a fairly thorough rundown of all the options.

HTH!

|||

Hi,

YOU CAN RETRIEVE THE BACKUP DATA FROM THE DELETED DATA..

I AM WORKING WITH SQL SERVER 2005.

JUST TRY ONCE AFTER THAT YOU CAN!!!!!!!!!!

REcovery model for a backup/restore operation

Hello,
I want to do a backup and restore operations of my base, using SQLCMD.exe.
For that, I use backup database mybase to disk='File'
Then, I try to do a backup of transact log but like this:
backup log mybase to disk='File'
But I have this message : Cannot do a backup log on database which is a
simple recovery model.
I read the BOL and I saw there are to type of recovery model: Simple and
full. But I didn't understand very well explications in BOL.
My questions are:
What are this models?
When are they used ?
ThanksIn simple mode, not very much is logged in the transaction log. In full,
almost everything is logged in the transaction log. Thats the basic
difference. Theres a whole lot more to it, so it wouldn be a bad idea to
read up on it.
oh yeah, theres also bulk logged recovery model :)
MC
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:A0AF25DC-B42D-4AF4-9C3E-0F5722B689F8@.microsoft.com...
> Hello,
> I want to do a backup and restore operations of my base, using SQLCMD.exe.
> For that, I use backup database mybase to disk='File'
> Then, I try to do a backup of transact log but like this:
> backup log mybase to disk='File'
> But I have this message : Cannot do a backup log on database which is a
> simple recovery model.
> I read the BOL and I saw there are to type of recovery model: Simple and
> full. But I didn't understand very well explications in BOL.
> My questions are:
> What are this models?
> When are they used ?
> Thanks
>|||Hi, bubixx.
http://vyaskn.tripod.com/ sql_serve...ices
.htm
In this URL you will find a very good white paper about backups and other
administration practices.
Good luck.
Pau.
"bubixx" <bubixx@.discussions.microsoft.com> escribi en el mensaje
news:A0AF25DC-B42D-4AF4-9C3E-0F5722B689F8@.microsoft.com...
> Hello,
> I want to do a backup and restore operations of my base, using SQLCMD.exe.
> For that, I use backup database mybase to disk='File'
> Then, I try to do a backup of transact log but like this:
> backup log mybase to disk='File'
> But I have this message : Cannot do a backup log on database which is a
> simple recovery model.
> I read the BOL and I saw there are to type of recovery model: Simple and
> full. But I didn't understand very well explications in BOL.
> My questions are:
> What are this models?
> When are they used ?
> Thanks
>|||> In simple mode, not very much is logged in the transaction log. In full, almost everythin
g is
> logged in the transaction log.
IMO, that is too much of a simplification. For all but a few special operati
ons, the amount logged
is the same for all recovery models. In simple, SQL Server will by itself em
pty the log each time it
does a checkpoint. In full mode, you have to empty the log using BACKUP LOG.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message news:uOAqxL07FHA.2092@.TK2MSFTNGP12.phx.gb
l...
> In simple mode, not very much is logged in the transaction log. In full, a
lmost everything is
> logged in the transaction log. Thats the basic difference. Theres a whole
lot more to it, so it
> wouldn be a bad idea to read up on it.
> oh yeah, theres also bulk logged recovery model :)
>
> MC
> "bubixx" <bubixx@.discussions.microsoft.com> wrote in message
> news:A0AF25DC-B42D-4AF4-9C3E-0F5722B689F8@.microsoft.com...
>|||Well, thank you for that.
I thought to simplify as much as I can, since I didnt think that I should go
into explaining the transaction log as such. You managed to write a really
short explanation though, I'll have to use it next time someone asks me to
explain the difference ;).
MC
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eDetSr17FHA.2816@.tk2msftngp13.phx.gbl...
> IMO, that is too much of a simplification. For all but a few special
> operations, the amount logged is the same for all recovery models. In
> simple, SQL Server will by itself empty the log each time it does a
> checkpoint. In full mode, you have to empty the log using BACKUP LOG.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "MC" <marko_culo#@.#yahoo#.#com#> wrote in message
> news:uOAqxL07FHA.2092@.TK2MSFTNGP12.phx.gbl...
>|||> I thought to simplify as much as I can, since I didnt think that I should go into explain
ing the
> transaction log as such.
I figured that was the case. :-)

> , I'll have to use it next time someone asks me to explain the difference ;).[/col
or]
Feel free... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MC" <marko_culo#@.#yahoo#.#com#> wrote in message news:%23Sk2Iv17FHA.3660@.TK2MSFTNGP09.phx.
gbl...
> Well, thank you for that.
> I thought to simplify as much as I can, since I didnt think that I should
go into explaining the
> transaction log as such. You managed to write a really short explanation t
hough, I'll have to use
> it next time someone asks me to explain the difference ;).
>
> MC
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:eDetSr17FHA.2816@.tk2msftngp13.phx.gbl...
>|||Are you the admin of this server? I assume since you are performing backups.
If you are not sure about the difference between 'full' and 'simple'
recovery and how it affects backups, then it would be best to leave the
recovery model at it's default of 'full'.
SQL Server 2000 Administrator's Pocket Consultant: Database Backup and
Recovery
http://www.microsoft.com/technet/pr...s/c11ppcsq.mspx
SQL Server 2000 Operations Guide: System Administration
http://www.microsoft.com/technet/pr...in/sqlops4.mspx
"bubixx" <bubixx@.discussions.microsoft.com> wrote in message
news:A0AF25DC-B42D-4AF4-9C3E-0F5722B689F8@.microsoft.com...
> Hello,
> I want to do a backup and restore operations of my base, using SQLCMD.exe.
> For that, I use backup database mybase to disk='File'
> Then, I try to do a backup of transact log but like this:
> backup log mybase to disk='File'
> But I have this message : Cannot do a backup log on database which is a
> simple recovery model.
> I read the BOL and I saw there are to type of recovery model: Simple and
> full. But I didn't understand very well explications in BOL.
> My questions are:
> What are this models?
> When are they used ?
> Thanks
>

Recovery model backup and restore database

I want to do a backup and restore operations of my base, using SQLCMD.exe.

For that, I use backup database mybase to disk='File'

Then, I try to do a backup of transact log but like this:

backup log mybase to disk='File'

But I have this message : Cannot do a backup log on database which is a simple recovery model.

I read the BOL and I saw there are to type of recovery model: Simple and full. But I didn't understand very bien explications in BOL.

My questions are:

What is this models?

When are they used ?

ThanksRecovery model determines how the transaction log files are handled in the database. This is in turn affects performance, log file usage, backup/recovery, amount of data loss etc. Please refer to topic below for overview:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/606e0487-0c76-4875-af44-ef763cc5a73a.htm

You should also look at the transaction log architecture topic and why it is necessary in a relational database system.

Recovery from a Restore without replication info

Can anyone point me to a set of documented steps on how to clean up the
following mess?
Three days ago a developer (not me) deployed some changes to a production
database by restoring from a backup created on another server. The problem
is the production database was set for replication. Now there is an
inconsistency between the replication metadata stored in Master and
Distribution vs. the production database. The type of replication is
snapshot and the servers are all version 2005 SP1.
I've recovered from this exact same situation in SQL 2000 but never in 2005.
Unfortunately I didn't bother to document the steps. I dimly recall however
a lot of false starts and direct editing of the contents of the Master
database. I'd really love to avoid experimentation this time around.
Hi, Kevin,
To let me better understand your issue, coulder you please let me know the
follwing questions:
1. Who is the publisher?
2. Who is the distributor?
3. Who is the subscriber?
4. What is the type of your replication?
5. Could you please describe me more detailed of the inconsistency that you
mentioned?
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||As it is snapshot replication, what I'd do is to remove the publication, run
sp_removedbreplication on the relevant databases (assuming no other
publications there) and then readd the publication. If you have been backing
up your replication scripts (http://www.replicationanswers.com/Script7.asp)
this is pretty straightforward to do.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks for the suggestion. That's what I am going to try to do this morning.
I spent all part of yesterday setting up a test environment that reproduces
the problem. I know that on 2000 the system stored procs that delete
replication data from the Master and Distribution databases fail if the
publishing database does not contain replication metadata. My hope is that
the procs have been improved in 2005 and will no longer fail.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:e5JCCbGbHHA.4176@.TK2MSFTNGP02.phx.gbl...
> As it is snapshot replication, what I'd do is to remove the publication,
> run sp_removedbreplication on the relevant databases (assuming no other
> publications there) and then readd the publication. If you have been
> backing up your replication scripts
> (http://www.replicationanswers.com/Script7.asp) this is pretty
> straightforward to do.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
|||Hi, Kevin,
I am sorry that I missed reading that your replication type was snapshot.
Did you mean that your publication database was polluted?
In this case, you can just restore your publication database from the
latest dabase backup file since it is a snapshot replication; however there
may be data loss between the backup time to now.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Recovering Sql server

I'm restoring the full sql server, what do I have to do
first restore all databases or restore master database?
Thanks in advance,
LuzTypically it would be:
Master - to get config details back
MSDB - to get backuphistory The rest - using the backuphistory from msdb
But it does depend a little on the exact situation that leads you to =restore it all!!
Good luck
Mike John
"luz" <luz_mariac@.hotmail.com> wrote in message =news:064501c344cd$88bba850$a101280a@.phx.gbl...
> I'm restoring the full sql server, what do I have to do > first restore all databases or restore master database?
> > Thanks in advance,
> Luz

Recover Transaction Log

Hi - I'm requesting help to understand a concept:
Can you restore a Transaction Log Backup only Transaction Logs backed up
AFTER a Full Backup?
EXAMPLE: Setup assuming 2 hard drives:
* Database MDF files stored on hard drive (A)
* Database Transaction Log files soted on hard drive(B)
First, Lets assume a Full Backup has been peformed nightly for a week at
Midnight.
Second, lets also assume that a week ago I temporaily stoped the
every-2-hour-schedule for a Transaction Log Backup and forgot to turn the
schedule back on - Therefore no Transaction Log Backup occured during the
past week.
Now, lets assume that harddrive (A) crashes at noon today - but hard drive
(B) is ok and still works. I have a succesfull Full Backup at Midnight, so I
know I can restore that.
Question: After Restoring from the Midnight Full Backup, Can I use the
current Transaction Log file as of Noon to restore the remainder of the logs
,
even though it had not been backuped for 6 days? Or is it required that a
transaction log backup have occured at some point after the Full backup?> Question: After Restoring from the Midnight Full Backup, Can I use the
> current Transaction Log file as of Noon to restore the remainder of the lo
gs,
> even though it had not been backuped for 6 days?
No. The reason you can't do that is the when you do the restore, you will ov
erwrite the log records
in the ldf file. What you can do, is *before* you do the restore, backup the
log. You now have a
database backup and a log backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"labsRcool@.community.nospan" <labsRcoolcommunitynospan@.discussions.microsoft
.com> wrote in message
news:ACC73D9F-EE1A-4E2B-B25D-24F4927A8BC6@.microsoft.com...
> Hi - I'm requesting help to understand a concept:
> Can you restore a Transaction Log Backup only Transaction Logs backed up
> AFTER a Full Backup?
> EXAMPLE: Setup assuming 2 hard drives:
> * Database MDF files stored on hard drive (A)
> * Database Transaction Log files soted on hard drive(B)
> First, Lets assume a Full Backup has been peformed nightly for a week at
> Midnight.
> Second, lets also assume that a week ago I temporaily stoped the
> every-2-hour-schedule for a Transaction Log Backup and forgot to turn the
> schedule back on - Therefore no Transaction Log Backup occured during the
> past week.
> Now, lets assume that harddrive (A) crashes at noon today - but hard drive
> (B) is ok and still works. I have a succesfull Full Backup at Midnight, so
I
> know I can restore that.
> Question: After Restoring from the Midnight Full Backup, Can I use the
> current Transaction Log file as of Noon to restore the remainder of the lo
gs,
> even though it had not been backuped for 6 days? Or is it required that a
> transaction log backup have occured at some point after the Full backup?
>
>|||Thanks!
Follow up question:
If I do as you suggest, and Backup the current log, then I'm assuming the
process is as follows:
1)Restore Full Backup from the midnight backup
2)Restore the Log backup that I just "backed up" before the restore.
In regards to the Log restore, I'm assuming then, that the restore process
is smart enough to only include from the transaction log the transactions
that have occured since the Midnight backup...and will not attempt to
re-include(duplicate) the transaction over the last week. (i.e., it's now
just treated as a normal transaction log backup/restore as if it I had been
backing them up like I was supposed to ;)
Thanks!
"Tibor Karaszi" wrote:

> No. The reason you can't do that is the when you do the restore, you will
overwrite the log records
> in the ldf file. What you can do, is *before* you do the restore, backup t
he log. You now have a
> database backup and a log backup.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "labsRcool@.community.nospan" <labsRcoolcommunitynospan@.discussions.microso
ft.com> wrote in message
> news:ACC73D9F-EE1A-4E2B-B25D-24F4927A8BC6@.microsoft.com...
>|||Yes, that is correct. The database backup has all log records produced durin
g that database backup.
So, restore will copy in the data pages, and use the log records in the data
base backup to do the
REDO process. When you then restore the log backup, SQL Server will start th
e REDO operation from
the very last log record in the database backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"labsRcool@.community.nospan" <labsRcoolcommunitynospan@.discussions.microsoft
.com> wrote in message
news:0CED8BB9-8B1D-4E04-BD07-B9525D1A5037@.microsoft.com...[vbcol=seagreen]
> Thanks!
> Follow up question:
> If I do as you suggest, and Backup the current log, then I'm assuming the
> process is as follows:
> 1)Restore Full Backup from the midnight backup
> 2)Restore the Log backup that I just "backed up" before the restore.
> In regards to the Log restore, I'm assuming then, that the restore process
> is smart enough to only include from the transaction log the transactions
> that have occured since the Midnight backup...and will not attempt to
> re-include(duplicate) the transaction over the last week. (i.e., it's now
> just treated as a normal transaction log backup/restore as if it I had bee
n
> backing them up like I was supposed to ;)
> Thanks!
> "Tibor Karaszi" wrote:
>

Recover Transaction Log

Hi - I'm requesting help to understand a concept:
Can you restore a Transaction Log Backup only Transaction Logs backed up
AFTER a Full Backup?
EXAMPLE: Setup assuming 2 hard drives:
* Database MDF files stored on hard drive (A)
* Database Transaction Log files soted on hard drive(B)
First, Lets assume a Full Backup has been peformed nightly for a week at
Midnight.
Second, lets also assume that a week ago I temporaily stoped the
every-2-hour-schedule for a Transaction Log Backup and forgot to turn the
schedule back on - Therefore no Transaction Log Backup occured during the
past week.
Now, lets assume that harddrive (A) crashes at noon today - but hard drive
(B) is ok and still works. I have a succesfull Full Backup at Midnight, so I
know I can restore that.
Question: After Restoring from the Midnight Full Backup, Can I use the
current Transaction Log file as of Noon to restore the remainder of the logs,
even though it had not been backuped for 6 days? Or is it required that a
transaction log backup have occured at some point after the Full backup?
Thanks!
Follow up question:
If I do as you suggest, and Backup the current log, then I'm assuming the
process is as follows:
1)Restore Full Backup from the midnight backup
2)Restore the Log backup that I just "backed up" before the restore.
In regards to the Log restore, I'm assuming then, that the restore process
is smart enough to only include from the transaction log the transactions
that have occured since the Midnight backup...and will not attempt to
re-include(duplicate) the transaction over the last week. (i.e., it's now
just treated as a normal transaction log backup/restore as if it I had been
backing them up like I was supposed to ;)
Thanks!
"Tibor Karaszi" wrote:

> No. The reason you can't do that is the when you do the restore, you will overwrite the log records
> in the ldf file. What you can do, is *before* you do the restore, backup the log. You now have a
> database backup and a log backup.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "labsRcool@.community.nospan" <labsRcoolcommunitynospan@.discussions.microsoft.co m> wrote in message
> news:ACC73D9F-EE1A-4E2B-B25D-24F4927A8BC6@.microsoft.com...
>
sql

Recover the DTS packages

Hello, everyone:
A guy think that the DTS packages can be recoved by restore MSDB database. Is that true? Does anyone have experience on that? Thanks.
ZYThi's rihgt|||DTS packages can be saved in the sysdtspackages table of the MSDB database in SQL Server. DTS packages can also be saved outside of SQL Server in Meta Data Services, a structured storage file or a Visual Basic file.

Recover lost data after wrong backup restored

I have accidently restored a SQL database (using Force restore over existing
database in EM) using a backup which was 1 month older than the latest
backup, and have therefore lost some important data from the existing
database. Is there any way that I can recover the lost data?
Thanks for any help.Seen from SQL Server's viewpoint, the data has been physically overwritten.
Either hunt down a later backup, or see of there is any OS or possibly SAN l
evel utility that might
help you here (I wouldn't have much hope for this but think it is at least w
orth mentioning).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Williams" <johnwilliams_esquire@.NOhotmailSPAM.com> wrote in message
news:uSRIcb5rEHA.536@.TK2MSFTNGP11.phx.gbl...
>I have accidently restored a SQL database (using Force restore over existin
g
> database in EM) using a backup which was 1 month older than the latest
> backup, and have therefore lost some important data from the existing
> database. Is there any way that I can recover the lost data?
> Thanks for any help.
>
>

Recover lost data after wrong backup restored

I have accidently restored a SQL database (using Force restore over existing
database in EM) using a backup which was 1 month older than the latest
backup, and have therefore lost some important data from the existing
database. Is there any way that I can recover the lost data?
Thanks for any help.
Seen from SQL Server's viewpoint, the data has been physically overwritten.
Either hunt down a later backup, or see of there is any OS or possibly SAN level utility that might
help you here (I wouldn't have much hope for this but think it is at least worth mentioning).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Williams" <johnwilliams_esquire@.NOhotmailSPAM.com> wrote in message
news:uSRIcb5rEHA.536@.TK2MSFTNGP11.phx.gbl...
>I have accidently restored a SQL database (using Force restore over existing
> database in EM) using a backup which was 1 month older than the latest
> backup, and have therefore lost some important data from the existing
> database. Is there any way that I can recover the lost data?
> Thanks for any help.
>
>

Recover lost data after wrong backup restored

I have accidently restored a SQL database (using Force restore over existing
database in EM) using a backup which was 1 month older than the latest
backup, and have therefore lost some important data from the existing
database. Is there any way that I can recover the lost data?
Thanks for any help.Seen from SQL Server's viewpoint, the data has been physically overwritten.
Either hunt down a later backup, or see of there is any OS or possibly SAN level utility that might
help you here (I wouldn't have much hope for this but think it is at least worth mentioning).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Williams" <johnwilliams_esquire@.NOhotmailSPAM.com> wrote in message
news:uSRIcb5rEHA.536@.TK2MSFTNGP11.phx.gbl...
>I have accidently restored a SQL database (using Force restore over existing
> database in EM) using a backup which was 1 month older than the latest
> backup, and have therefore lost some important data from the existing
> database. Is there any way that I can recover the lost data?
> Thanks for any help.
>
>

Recover DB from c$

I am trying to restore a database. The backuo file is on c$. The restore
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?
Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Recover DB from c$

I am trying to restore a database. The backuo file is on c$. The restore
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Recover DB from c$

I am trying to restore a database. The backuo file is on c$. The restore
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Recover Database Help!

Hello,

Is it possible to restore a SQL 2000 database with data from a transaction log?

I am not sure what happened to my database, all the data in the tables is gone. I generated a db script to create a duplicate database. I saved the .sql file on my local machine, separate from the db server, renamed the database name in the .sql file to a new database. Tested script in query analyzer for syntax, all was fine. Running it at this point would have created a new database with a different name, right?

Now my original database is empty. Can someone please provide me with information on getting my data back. Is there a way of using the transaction log to recover the data.

ThanksIf you have backups and your db is set to full recovery, you can backup the trans log and issue the restore with StopAt.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_25rm.asp

You could also take a look at third party app, log explorer:
http://www.lumigent.com/products/le_sql.html|||In order to use the native SQL Server backups, you need to start from a full backup, which makes sense, since it is the only way to have a point to roll transactions forward from.

Recover database - HELP, PLEASE

Hello,
My database (MS SQL 2k) has been crushed some days ago. I've no any backup, but I need to restore information as much as possible. Trouble is... I've lost last file in filegroup (it's broken), that contents images only. (All images were in three .ndf files, 9Gb each of them).
Please, tell me - is it possible to restore any information?I haven't had to do this, but in SQL 2000 you may be able to attach the file (you do still have the file, don't you?) directly to the database, or perhaps as a new database from which you can recover your data.

Search SQL Books Online for "attaching databases", "sp_attach_db", or "sp_attach_single_file_db".

Good luck, and back up!

blindman

Recover data from Transaction Log

I wrong delete all contents of a table.
I was going to restore the full backup database but the file is corrupt.
I have:
The last 5 days backups of Transaction Log;
The actual Transaction Log;

Can you please give me any ideas of how to restore de transaction logs backups and/or uncommitted de deletion of all rows of the table.

Thanks,
PauloDuplicate post

http://www.dbforums.com/t976254.html

recover - how do I tell if it is really happening?

Hello all -
this is the first restore I've attempted on a real production database.
I used EM to execute the restore, and it correctly found my last full backup
, diffs and tran log files.
(I run full recovery mode).
I can see in the log where things are happening, and the status of the datab
ase is being displayed as loading.
But after 3.5 hours you just start to wonder if anything is really happening
.. Any advice?How long did the backup take? Restore is usually longer. Sometimes 2 or 3x
longer.
Run sp_who2 and see if the CPU and IO counters change for the restore task.
Watch the blinkey lights on the case.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:81408CF6-B061-4514-87C7-D582E3DF9058@.microsoft.com...
> Hello all -
> this is the first restore I've attempted on a real production database.
> I used EM to execute the restore, and it correctly found my last full
backup, diffs and tran log files.
> (I run full recovery mode).
> I can see in the log where things are happening, and the status of the
database is being displayed as loading.
> But after 3.5 hours you just start to wonder if anything is really
happening... Any advice?|||Hi Randy.
For future reference, you might find RESTORE's STATS option useful. I use
this pretty much on autopilot - RESTORE.. WITH STATS=10 - it writes a
progress response to the console / query analyser every 10 percent. That way
you get an idea of how far the restore's progressed.
HTH
Regards,
Greg Linwood
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:81408CF6-B061-4514-87C7-D582E3DF9058@.microsoft.com...
> Hello all -
> this is the first restore I've attempted on a real production database.
> I used EM to execute the restore, and it correctly found my last full
backup, diffs and tran log files.
> (I run full recovery mode).
> I can see in the log where things are happening, and the status of the
database is being displayed as loading.
> But after 3.5 hours you just start to wonder if anything is really
happening... Any advice?|||Hi Randy,
I am reviewing your post and we have not heard from you for some time. I
want to know if your restore is fine now. Our community members have
provide some informaitons by using WITH STATS in recovery and it might be
longer than backup. If you still have questions, please feel free to let me
know and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

recover - how do I tell if it is really happening?

Hello all -
this is the first restore I've attempted on a real production database.
I used EM to execute the restore, and it correctly found my last full backup, diffs and tran log files.
(I run full recovery mode).
I can see in the log where things are happening, and the status of the database is being displayed as loading.
But after 3.5 hours you just start to wonder if anything is really happening... Any advice?
How long did the backup take? Restore is usually longer. Sometimes 2 or 3x
longer.
Run sp_who2 and see if the CPU and IO counters change for the restore task.
Watch the blinkey lights on the case.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:81408CF6-B061-4514-87C7-D582E3DF9058@.microsoft.com...
> Hello all -
> this is the first restore I've attempted on a real production database.
> I used EM to execute the restore, and it correctly found my last full
backup, diffs and tran log files.
> (I run full recovery mode).
> I can see in the log where things are happening, and the status of the
database is being displayed as loading.
> But after 3.5 hours you just start to wonder if anything is really
happening... Any advice?
|||Hi Randy.
For future reference, you might find RESTORE's STATS option useful. I use
this pretty much on autopilot - RESTORE.. WITH STATS=10 - it writes a
progress response to the console / query analyser every 10 percent. That way
you get an idea of how far the restore's progressed.
HTH
Regards,
Greg Linwood
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:81408CF6-B061-4514-87C7-D582E3DF9058@.microsoft.com...
> Hello all -
> this is the first restore I've attempted on a real production database.
> I used EM to execute the restore, and it correctly found my last full
backup, diffs and tran log files.
> (I run full recovery mode).
> I can see in the log where things are happening, and the status of the
database is being displayed as loading.
> But after 3.5 hours you just start to wonder if anything is really
happening... Any advice?
|||Hi Randy,
I am reviewing your post and we have not heard from you for some time. I
want to know if your restore is fine now. Our community members have
provide some informaitons by using WITH STATS in recovery and it might be
longer than backup. If you still have questions, please feel free to let me
know and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.