Showing posts with label drive. Show all posts
Showing posts with label drive. Show all posts

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

Saturday, February 25, 2012

data manipulation group by problem

Hi I have a data manipulation query. I have the table below which gets
populated on a daily basis
CREATE TABLE [dbo].[FreeSpace] (
[Drive] [char] (1) not null ,
[MB_Free] [int] not null ,
[day_time] [datetime] default getdate()NOT NULL
) ON [PRIMARY]
insert into FreeSpace(Drive,MB_Free) exec master..xp_fixeddrives--this
populates table
I run the query included below but the data comes out as example below
drive monday tuesday etc....
c 100mb null
c null 100mb
d 200mb null
d null 200mb
I would like to display like this
drive monday tuesday etc....
c 100mb 100mb
D 200mb 200mb
My query below
SELECT Drive,
case datepart(dd, day_time) when 1 then cast(mb_free as varchar (12)) +' MB
Free Space'
end as Monday,
case datepart(dd, day_time) when 2 then cast(mb_free as varchar (12)) +' MB
Free Space'
end as Tuesday,
case datepart(dd, day_time) when 3 then cast(mb_free as varchar (12)) +' MB
Free Space'
end as Wednesday,
case datepart(dd, day_time) when 4 then cast(mb_free as varchar (12)) +' MB
Free Space'
end as Thursday,
case datepart(dd, day_time) when 5 then cast(mb_free as varchar (12)) +' MB
Free Space'
end as Friday,
case datepart(dd, day_time) when 6 then cast(mb_free as varchar (12)) +' MB
Free Space'
end as Saturday,
case datepart(dd, day_time) when 7 then cast(mb_free as varchar (12)) +' MB
Free Space'
end as Sunday
from FreeSpace
group by Drive,datepart(dd, day_time),MB_Free
order by drive
thanks for any help
SammySammy
See if this helps you
SELECT Drive,
MAX(case datepart(dd, day_time) when 1 then cast(mb_free as varchar (12)) +'
MB
Free Space'
end) as Monday,
MAX(case datepart(dd, day_time) when 2 then cast(mb_free as varchar (12)) +'
MB
Free Space'
end )as Tuesday
......
from FreeSpace
group by Drive
order by drive
"Sammy" <Sammy@.discussions.microsoft.com> wrote in message
news:E4C10338-8829-42B6-A3B9-F87B1224EFF9@.microsoft.com...
> Hi I have a data manipulation query. I have the table below which gets
> populated on a daily basis
> CREATE TABLE [dbo].[FreeSpace] (
> [Drive] [char] (1) not null ,
> [MB_Free] [int] not null ,
> [day_time] [datetime] default getdate()NOT NULL
> ) ON [PRIMARY]
> insert into FreeSpace(Drive,MB_Free) exec master..xp_fixeddrives--this
> populates table
> I run the query included below but the data comes out as example below
> drive monday tuesday etc....
> c 100mb null
> c null 100mb
> d 200mb null
> d null 200mb
> I would like to display like this
> drive monday tuesday etc....
> c 100mb 100mb
> D 200mb 200mb
> My query below
> SELECT Drive,
> case datepart(dd, day_time) when 1 then cast(mb_free as varchar (12)) +'
> MB
> Free Space'
> end as Monday,
> case datepart(dd, day_time) when 2 then cast(mb_free as varchar (12)) +'
> MB
> Free Space'
> end as Tuesday,
> case datepart(dd, day_time) when 3 then cast(mb_free as varchar (12)) +'
> MB
> Free Space'
> end as Wednesday,
> case datepart(dd, day_time) when 4 then cast(mb_free as varchar (12)) +'
> MB
> Free Space'
> end as Thursday,
> case datepart(dd, day_time) when 5 then cast(mb_free as varchar (12)) +'
> MB
> Free Space'
> end as Friday,
> case datepart(dd, day_time) when 6 then cast(mb_free as varchar (12)) +'
> MB
> Free Space'
> end as Saturday,
> case datepart(dd, day_time) when 7 then cast(mb_free as varchar (12)) +'
> MB
> Free Space'
> end as Sunday
> from FreeSpace
> group by Drive,datepart(dd, day_time),MB_Free
> order by drive
> thanks for any help
> Sammy|||Thanks Uri
"Sammy" wrote:

> Hi I have a data manipulation query. I have the table below which gets
> populated on a daily basis
> CREATE TABLE [dbo].[FreeSpace] (
> [Drive] [char] (1) not null ,
> [MB_Free] [int] not null ,
> [day_time] [datetime] default getdate()NOT NULL
> ) ON [PRIMARY]
> insert into FreeSpace(Drive,MB_Free) exec master..xp_fixeddrives--this
> populates table
> I run the query included below but the data comes out as example below
> drive monday tuesday etc....
> c 100mb null
> c null 100mb
> d 200mb null
> d null 200mb
> I would like to display like this
> drive monday tuesday etc....
> c 100mb 100mb
> D 200mb 200mb
> My query below
> SELECT Drive,
> case datepart(dd, day_time) when 1 then cast(mb_free as varchar (12)) +' M
B
> Free Space'
> end as Monday,
> case datepart(dd, day_time) when 2 then cast(mb_free as varchar (12)) +' M
B
> Free Space'
> end as Tuesday,
> case datepart(dd, day_time) when 3 then cast(mb_free as varchar (12)) +' M
B
> Free Space'
> end as Wednesday,
> case datepart(dd, day_time) when 4 then cast(mb_free as varchar (12)) +' M
B
> Free Space'
> end as Thursday,
> case datepart(dd, day_time) when 5 then cast(mb_free as varchar (12)) +' M
B
> Free Space'
> end as Friday,
> case datepart(dd, day_time) when 6 then cast(mb_free as varchar (12)) +' M
B
> Free Space'
> end as Saturday,
> case datepart(dd, day_time) when 7 then cast(mb_free as varchar (12)) +' M
B
> Free Space'
> end as Sunday
> from FreeSpace
> group by Drive,datepart(dd, day_time),MB_Free
> order by drive
> thanks for any help
> Sammy