Data transformation services: restore

Showing posts with label restore. Show all posts

Thursday, March 22, 2012

Data Restore on Elm Street!

Hi all, a bit of a nasty one here!

Ive inherited a server that has just collapsed. It contains SQL Server
and has a fair amount of data on it.

The server would only boot into a BSOD Stop Error. I suspected that
one of the hives in the registry was corrupt so I used the Win2K
Recovery Console to restore the registry to its original settings (So
Windows can not see the SQL stuff now). There is no restore points
from which to take recent registry settings.

My Question is this...

We have a spare server (just lying about you know!!!) which we plan to
install Win2K and MS SQL Server onto... How can I transfer the data,
in a nice easy manner, from the old server to the new server?

Is it possible to move just the data files into the new install?

Remember I inherited this server! (I dont have Backups!!!)
Please... No email's about how important backups are... I know how
important backups are.

Any help/ideas would be appreciated.

Thanks, John T.You can certainly try

Exec sp_attach_db (details in BOL)

There are times when this will only work if you have explicitly used
sp_detach_db (details in BOL)

Failing that and no backups then you may want to give the boys and girls in
PSS a bell.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"John Tear" <johntear@.hotmail.com> wrote in message
news:92ae3244.0404150027.72b19847@.posting.google.c om...
> Hi all, a bit of a nasty one here!
> Ive inherited a server that has just collapsed. It contains SQL Server
> and has a fair amount of data on it.
> The server would only boot into a BSOD Stop Error. I suspected that
> one of the hives in the registry was corrupt so I used the Win2K
> Recovery Console to restore the registry to its original settings (So
> Windows can not see the SQL stuff now). There is no restore points
> from which to take recent registry settings.
> My Question is this...
> We have a spare server (just lying about you know!!!) which we plan to
> install Win2K and MS SQL Server onto... How can I transfer the data,
> in a nice easy manner, from the old server to the new server?
> Is it possible to move just the data files into the new install?
> Remember I inherited this server! (I dont have Backups!!!)
> Please... No email's about how important backups are... I know how
> important backups are.
> Any help/ideas would be appreciated.
> Thanks, John T.|||Hi Allan

Thanks for your reply. I got this sorted, basically I took the data
files and transfered them accross to the new server then I attached
them in the management console for MS SQL. Pretty lucky I think!

I have advised that a backup solution is the VERY next step!!!

John T.

"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message news:<407e4e4e$0$31686$fa0fcedb@.lovejoy.zen.co.uk>...
> You can certainly try
> Exec sp_attach_db (details in BOL)
> There are times when this will only work if you have explicitly used
> sp_detach_db (details in BOL)
>
> Failing that and no backups then you may want to give the boys and girls in
> PSS a bell.
> --
> --
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "John Tear" <johntear@.hotmail.com> wrote in message
> news:92ae3244.0404150027.72b19847@.posting.google.c om...
> > Hi all, a bit of a nasty one here!
> > Ive inherited a server that has just collapsed. It contains SQL Server
> > and has a fair amount of data on it.
> > The server would only boot into a BSOD Stop Error. I suspected that
> > one of the hives in the registry was corrupt so I used the Win2K
> > Recovery Console to restore the registry to its original settings (So
> > Windows can not see the SQL stuff now). There is no restore points
> > from which to take recent registry settings.
> > My Question is this...
> > We have a spare server (just lying about you know!!!) which we plan to
> > install Win2K and MS SQL Server onto... How can I transfer the data,
> > in a nice easy manner, from the old server to the new server?
> > Is it possible to move just the data files into the new install?
> > Remember I inherited this server! (I dont have Backups!!!)
> > Please... No email's about how important backups are... I know how
> > important backups are.
> > Any help/ideas would be appreciated.
> > Thanks, John T.|||Hi Allan

I have advised that a backup solution is the VERY next step!!!

John T.

Data Restore on Elm Street!

Hi all, a bit of a nasty one here!

Ive inherited a server that has just collapsed. It contains SQL Server
and has a fair amount of data on it.

My Question is this...

Is it possible to move just the data files into the new install?

Remember I inherited this server! (I dont have Backups!!!)
Please... No email's about how important backups are... I know how
important backups are.

Any help/ideas would be appreciated.

Thanks, John T.You can certainly try

Exec sp_attach_db (details in BOL)

There are times when this will only work if you have explicitly used
sp_detach_db (details in BOL)

Failing that and no backups then you may want to give the boys and girls in
PSS a bell.

--
--

Data restore help

The database server crashed and i am trying to restore database. I have all the mdf, ldf and bak files. I tried to attach, import and restore but nothing is working. It just gives this error,

TITLE: Microsoft SQL Server Management Studio
An Exception occurred while executing a Transact-SQL statement or batch (Microsoft.Sqlserver.ConnectionInfo)

Additional Information:
The media family on device 'D:\Databases\inv.bak' is incorrectly formed. SQL Server cannont process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

Anyone, please help.

Thanks

Subasis

Do you get the same error when you try to attach the database files (mdf & ldf)?|||The first thing I would do is run a RESTORE HEADERONLY and a RESTORE VERIFYONLY combination to check whether you have a valid backup|||

Hi TimDBA,

When i tried to attach file, it gave error 5171 (The given file is not a primary database file). As far as I know, it is the primary database file that was restored from data directory of MS SQL server directory.

Hope to get your response. Thanks

Subasis

|||

Hi bass_player

I tried as you've said using restore headeronly but it gave "The file is incorrectly formed and SQL server cannot process this media family'.

Thanks

Subasis

Tuesday, March 20, 2012

Data recovery service!

I've been asked to find a data recovery service who can help restore a sql
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?
Since most drives (disk arrays) are multiple spindles in a RAID configuration
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:

> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>
|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.

> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

Data recovery service!

I've been asked to find a data recovery service who can help restore a sql
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?Since most drives (disk arrays) are multiple spindles in a RAID configuration
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.
> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>> I've been asked to find a data recovery service who can help restore a
>> sql server database that has become corrupt or is on a hard drive that
>> has become non-functional. Does anyone have suggestions of a company who
>> specializes in this sort of work?
>
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

Data recovery service!

I've been asked to find a data recovery service who can help restore a sql
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?Since most drives (disk arrays) are multiple spindles in a RAID configuratio
n
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:

> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.

> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

data recovery

Hello All,
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table.
Thanks in advance
Hugo
Unfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.
|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
sql

data recovery

Hello All
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table
Thanks in advanc
HugUnfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>

data recovery

Hello All,
Is there a way to restore/recover data from an earlier date if you donot hav
e a backup. The data was accidentally deleted from a table.
Thanks in advance
HugoUnfortunately, if you do not have a backup (and more importantly are using t
ransaction log backups (to be able to restore to a specific point-in-time)),
then unfortunately there is not a way to recover the database back to it's
state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a ba
ckup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>

Thursday, March 22, 2012

Data Restore on Elm Street!

Data Restore on Elm Street!

Data restore help

Tuesday, March 20, 2012

Data recovery service!

Data recovery service!

Data recovery service!

data recovery

data recovery

data recovery

Data transformation services

Blog Archive

About Me