469,609 Members | 1,664 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Is it possiable to restore a DB ...

Hi,
I've written a M.plan in my client place which is scheduled to occur
weekly once.But 4 days gone from the last backup taken , there is a
problem in the server which does not start loading windows .The only
way is entering via SAFE-MODE.In the safe mode the E.Manage does not
connected(is it due to safe-mode).
They told they going to format the system . Since the E.M is not
connected, I just copied only my DB(.mdf) and the log file(.ldf).After
that i come accross that all the system databases should be backed up
along with the User DB then only possible for Restoration.

My request is

Is it not possiable to restore my copied DB(.MDF) (not backed up)
After reinstallation of Sql server.

With Heartfull thanks
Raghu
Jul 20 '05 #1
2 4768

"Raghuraman" <ra************@rediffmail.com> wrote in message
news:66**************************@posting.google.c om...
Hi,
I've written a M.plan in my client place which is scheduled to occur
weekly once.But 4 days gone from the last backup taken , there is a
problem in the server which does not start loading windows .The only
way is entering via SAFE-MODE.In the safe mode the E.Manage does not
connected(is it due to safe-mode).
They told they going to format the system . Since the E.M is not
connected, I just copied only my DB(.mdf) and the log file(.ldf).After
that i come accross that all the system databases should be backed up
along with the User DB then only possible for Restoration.

My request is

Is it not possiable to restore my copied DB(.MDF) (not backed up)
After reinstallation of Sql server.

With Heartfull thanks
Raghu


I saw something already written in this newgroup today that may help.

Subject: attach db file copied previously

Comand: sp_attach_single_file_db


Jul 20 '05 #2

"Raghuraman" <ra************@rediffmail.com> wrote in message
news:66**************************@posting.google.c om...
Hi,
I've written a M.plan in my client place which is scheduled to occur
weekly once.But 4 days gone from the last backup taken , there is a
problem in the server which does not start loading windows .The only
way is entering via SAFE-MODE.In the safe mode the E.Manage does not
connected(is it due to safe-mode).
They told they going to format the system . Since the E.M is not
connected, I just copied only my DB(.mdf) and the log file(.ldf).After
that i come accross that all the system databases should be backed up
along with the User DB then only possible for Restoration.
If possible you want to backup all the system DBs, especially the MSDB or
you risk losing jobs, etc.

So, if you can grab copies of the MDF and LDF of that to, that will help.

My request is

Is it not possiable to restore my copied DB(.MDF) (not backed up)
If you have the MDF and LDF then sp_attach_db is your best bet. If you have
only the .MDF, you MAY be able to use sp_attach_single_file_db, but
generally that will NOT work unless you used sp_detach_db in the first
place.

However, if you have just the MDF and can't attach it, contact Microsoft
Server Support. They may be able to help you, but your DB is likely to be
in an inconsistent state.

Note: If you're doing full backups only weekly, I highly recommend
differential or transactional backups on a daily basis (or even more often.)

After reinstallation of Sql server.

With Heartfull thanks
Raghu

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by For example John Smith | last post: by
1 post views Thread by Raghuraman | last post: by
4 posts views Thread by Hardy | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
9 posts views Thread by Raghuram | last post: by
reply views Thread by Solution2021 | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.