Database Unit Testing: hdd

Showing posts with label hdd. Show all posts

Sunday, March 11, 2012

Database retains size

Hello,
I have this 10 GB size database and unfortunately i'm running out of space
in my HDD. I'm using SQL Server 2000.
before i use dbcc shrink file on the database data file, the result of
sp_spaceused are the following:
db_name database_size unallocated space
abc 10881.70 MB -2526.48 MB
After I use: DBCC SHRINKFILE (abc_data, 10000)
I reduce the data file to aprox 10000, that is 800 Megs.
That all works fine, but next day as I check my DB the database size returns
to it's original size.
There's no way that in one night 800 megs of data is inserted in the
database.
I execute DBCC Reindex on 2 tables at night and do some backups..
Do you have any idea of what's maybe happening?
Any tip for regain some space?
Thanks
Eduardo SicouretWhat growth rate do you have specified in the database properties?|||What recovery model is the database in?
You can set up a trace to see when the database is growing. There are
database and log file growth events.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Eduardo Sicouret" <esicouret> wrote in message
news:esf4dxwiGHA.3848@.TK2MSFTNGP04.phx.gbl...
Hello,
I have this 10 GB size database and unfortunately i'm running out of space
in my HDD. I'm using SQL Server 2000.
before i use dbcc shrink file on the database data file, the result of
sp_spaceused are the following:
db_name database_size unallocated space
abc 10881.70 MB -2526.48 MB
After I use: DBCC SHRINKFILE (abc_data, 10000)
I reduce the data file to aprox 10000, that is 800 Megs.
That all works fine, but next day as I check my DB the database size returns
to it's original size.
There's no way that in one night 800 megs of data is inserted in the
database.
I execute DBCC Reindex on 2 tables at night and do some backups..
Do you have any idea of what's maybe happening?
Any tip for regain some space?
Thanks
Eduardo Sicouret|||File growth is automatically 64 megs at a time.
ESB
"Tracy McKibben" <tracy.mckibben@.gmail.com> escribió en el mensaje
news:1149779303.783251.118980@.j55g2000cwa.googlegroups.com...
> What growth rate do you have specified in the database properties?
>|||Recovery model is FULL and Autoshrink, Auto update statistics, auto create
statistics are checked
ESB
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> escribió en el mensaje
news:%23zoKn2wiGHA.4776@.TK2MSFTNGP05.phx.gbl...
> What recovery model is the database in?
> You can set up a trace to see when the database is growing. There are
> database and log file growth events.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Eduardo Sicouret" <esicouret> wrote in message
> news:esf4dxwiGHA.3848@.TK2MSFTNGP04.phx.gbl...
> Hello,
> I have this 10 GB size database and unfortunately i'm running out of space
> in my HDD. I'm using SQL Server 2000.
> before i use dbcc shrink file on the database data file, the result of
> sp_spaceused are the following:
> db_name database_size unallocated space
> abc 10881.70 MB -2526.48 MB
> After I use: DBCC SHRINKFILE (abc_data, 10000)
> I reduce the data file to aprox 10000, that is 800 Megs.
> That all works fine, but next day as I check my DB the database size
> returns
> to it's original size.
> There's no way that in one night 800 megs of data is inserted in the
> database.
> I execute DBCC Reindex on 2 tables at night and do some backups..
> Do you have any idea of what's maybe happening?
> Any tip for regain some space?
> Thanks
> Eduardo Sicouret
>
>|||I bet the reindex job is leaving unused space in your db. Run DBCC
UPDATEUSAGE after rebuilding the indexes and see if that helps. Ken.
Eduardo Sicouret wrote:
> Recovery model is FULL and Autoshrink, Auto update statistics, auto create
> statistics are checked
> ESB
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> escribi=F3 en el mensaje
> news:%23zoKn2wiGHA.4776@.TK2MSFTNGP05.phx.gbl...
> > What recovery model is the database in?
> >
> > You can set up a trace to see when the database is growing. There are
> > database and log file growth events.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> >
> >
> > "Eduardo Sicouret" <esicouret> wrote in message
> > news:esf4dxwiGHA.3848@.TK2MSFTNGP04.phx.gbl...
> > Hello,
> >
> > I have this 10 GB size database and unfortunately i'm running out of sp=ace
> > in my HDD. I'm using SQL Server 2000.
> >
> > before i use dbcc shrink file on the database data file, the result of
> > sp_spaceused are the following:
> >
> > db_name database_size unallocated space
> > abc 10881.70 MB -2526.48 MB
> >
> > After I use: DBCC SHRINKFILE (abc_data, 10000)
> >
> > I reduce the data file to aprox 10000, that is 800 Megs.
> >
> > That all works fine, but next day as I check my DB the database size
> > returns
> > to it's original size.
> >
> > There's no way that in one night 800 megs of data is inserted in the
> > database.
> >
> > I execute DBCC Reindex on 2 tables at night and do some backups..
> >
> > Do you have any idea of what's maybe happening?
> > Any tip for regain some space?
> >
> > Thanks
> >
> > Eduardo Sicouret
> >
> >
> >|||How big are the tables you're reindexing, and are there clustered
indexes on them? If these are large tables with clustered indexes, the
reindex operation is likely causing the database to grow.
Eduardo Sicouret wrote:
> File growth is automatically 64 megs at a time.
> ESB
> "Tracy McKibben" <tracy.mckibben@.gmail.com> escribi=F3 en el mensaje
> news:1149779303.783251.118980@.j55g2000cwa.googlegroups.com...
> > What growth rate do you have specified in the database properties?
> >|||You shrink the file, then reindex which need a lot of working space which is why the size blows up.
If you shrink again, the reindex is basically undone again. Bottom line is that if you want best
performance, you need this working space. Some extra info here:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Eduardo Sicouret" <esicouret> wrote in message news:esf4dxwiGHA.3848@.TK2MSFTNGP04.phx.gbl...
> Hello,
> I have this 10 GB size database and unfortunately i'm running out of space in my HDD. I'm using
> SQL Server 2000.
> before i use dbcc shrink file on the database data file, the result of sp_spaceused are the
> following:
> db_name database_size unallocated space
> abc 10881.70 MB -2526.48 MB
> After I use: DBCC SHRINKFILE (abc_data, 10000)
> I reduce the data file to aprox 10000, that is 800 Megs.
> That all works fine, but next day as I check my DB the database size returns to it's original
> size.
> There's no way that in one night 800 megs of data is inserted in the database.
> I execute DBCC Reindex on 2 tables at night and do some backups..
> Do you have any idea of what's maybe happening?
> Any tip for regain some space?
> Thanks
> Eduardo Sicouret
>|||Should also probably point out that all this
shrinking/growing/shrinking/growing is going to severly fragment the
database file, eventually hurting performance.
Tibor Karaszi wrote:
> You shrink the file, then reindex which need a lot of working space which is why the size blows up.
> If you shrink again, the reindex is basically undone again. Bottom line is that if you want best
> performance, you need this working space. Some extra info here:
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Eduardo Sicouret" <esicouret> wrote in message news:esf4dxwiGHA.3848@.TK2MSFTNGP04.phx.gbl...
> > Hello,
> >
> > I have this 10 GB size database and unfortunately i'm running out of space in my HDD. I'm using
> > SQL Server 2000.
> >
> > before i use dbcc shrink file on the database data file, the result of sp_spaceused are the
> > following:
> >
> > db_name database_size unallocated space
> > abc 10881.70 MB -2526.48 MB
> >
> > After I use: DBCC SHRINKFILE (abc_data, 10000)
> >
> > I reduce the data file to aprox 10000, that is 800 Megs.
> >
> > That all works fine, but next day as I check my DB the database size returns to it's original
> > size.
> >
> > There's no way that in one night 800 megs of data is inserted in the database.
> >
> > I execute DBCC Reindex on 2 tables at night and do some backups..
> >
> > Do you have any idea of what's maybe happening?
> > Any tip for regain some space?
> >
> > Thanks
> >
> > Eduardo Sicouret
> >|||"Eduardo Sicouret" <esicouret> wrote in message
news:%234bwfGxiGHA.4372@.TK2MSFTNGP03.phx.gbl...
> Recovery model is FULL and Autoshrink, Auto update statistics, auto create
> statistics are checked
>
I'd disable Autoshrink btw.
Growing and shrinking your DB can lead to disk level fragmentation.|||See whether you can shrink your logfile.. too..
"Eduardo Sicouret" <esicouret> wrote in message
news:esf4dxwiGHA.3848@.TK2MSFTNGP04.phx.gbl...
> Hello,
> I have this 10 GB size database and unfortunately i'm running out of space
> in my HDD. I'm using SQL Server 2000.
> before i use dbcc shrink file on the database data file, the result of
> sp_spaceused are the following:
> db_name database_size unallocated space
> abc 10881.70 MB -2526.48 MB
> After I use: DBCC SHRINKFILE (abc_data, 10000)
> I reduce the data file to aprox 10000, that is 800 Megs.
> That all works fine, but next day as I check my DB the database size
> returns to it's original size.
> There's no way that in one night 800 megs of data is inserted in the
> database.
> I execute DBCC Reindex on 2 tables at night and do some backups..
> Do you have any idea of what's maybe happening?
> Any tip for regain some space?
> Thanks
> Eduardo Sicouret
>

Database retains size

Friday, February 24, 2012

database recovery

Database Recovery

Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.
if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Pleace help me.
Thanks.inter
Do you have a last full backup of the database?
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||As I indicated in my response to your earlier posting (10/27) about the same
issue:
That doesn't sound very good, and since you do NOT have a backup of the
database, it does it sound very hopeful to recover the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
See: http://support.microsoft.com/defaul...S;offerprophone
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||Next time if you don't have UPS backup , Enable Torn Page Detection.
Thanks
Ajay
Arnie Rowland wrote:[vbcol=seagreen]
> As I indicated in my response to your earlier posting (10/27) about the sa
me
> issue:
> That doesn't sound very good, and since you do NOT have a backup of the
> database, it does it sound very hopeful to recover the 'lost' data.
> You may wish to contact PSS and open a ticket. They 'may' be able to help
> you.
> See: http://support.microsoft.com/defaul...S;offerprophone
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "inter" <halit-goktas.net> wrote in message
> news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...|||Hi,
If your data is critical please contact Microsoft PSS as Arnie suggested...
Thanks
Hari
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>

database recovery

The SBS 2003 server is blue screening. The client has not done any backup in
several months. I have pluged in another HDD, installed Standard 2003 and
then reconnected the old HDD as a second drive. All the data from the old HDD
is now visible and accessible. I can now comfortably recover all their data
except SQL database. Is there any way? Please help. Thanks in advance.
ChrisYou might be able to attach the database files to the new installation. Read about sp_attach_db.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Chris Toffa" <ChrisToffa@.discussions.microsoft.com> wrote in message
news:289C92F0-38BF-40DE-B60D-D464F876DBCC@.microsoft.com...
> The SBS 2003 server is blue screening. The client has not done any backup in
> several months. I have pluged in another HDD, installed Standard 2003 and
> then reconnected the old HDD as a second drive. All the data from the old HDD
> is now visible and accessible. I can now comfortably recover all their data
> except SQL database. Is there any way? Please help. Thanks in advance.
> Chris|||Tibor Im curious about your response. You say he "might" be able to attach,
what circumstances make this possible?
"Tibor Karaszi" wrote:
> You might be able to attach the database files to the new installation. Read about sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Chris Toffa" <ChrisToffa@.discussions.microsoft.com> wrote in message
> news:289C92F0-38BF-40DE-B60D-D464F876DBCC@.microsoft.com...
> > The SBS 2003 server is blue screening. The client has not done any backup in
> > several months. I have pluged in another HDD, installed Standard 2003 and
> > then reconnected the old HDD as a second drive. All the data from the old HDD
> > is now visible and accessible. I can now comfortably recover all their data
> > except SQL database. Is there any way? Please help. Thanks in advance.
> >
> > Chris
>|||As long as there was no physical damage to the data or log files it should
work. When it attaches it will go thru recovery and roll forward or back as
needed to make the db consistent.
--
Andrew J. Kelly SQL MVP
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:ECD839A1-AC24-45BC-94D2-306A82B9397C@.microsoft.com...
> Tibor Im curious about your response. You say he "might" be able to
> attach,
> what circumstances make this possible?
> "Tibor Karaszi" wrote:
>> You might be able to attach the database files to the new installation.
>> Read about sp_attach_db.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Chris Toffa" <ChrisToffa@.discussions.microsoft.com> wrote in message
>> news:289C92F0-38BF-40DE-B60D-D464F876DBCC@.microsoft.com...
>> > The SBS 2003 server is blue screening. The client has not done any
>> > backup in
>> > several months. I have pluged in another HDD, installed Standard 2003
>> > and
>> > then reconnected the old HDD as a second drive. All the data from the
>> > old HDD
>> > is now visible and accessible. I can now comfortably recover all their
>> > data
>> > except SQL database. Is there any way? Please help. Thanks in advance.
>> >
>> > Chris
>>|||> Tibor Im curious about your response. You say he "might" be able to attach,
> what circumstances make this possible?
Below is a quote from Books Online (2000) , sp_attach_db
"sp_attach_db should only be executed on databases that were previously detached from the database
server using an explicit sp_detach_db operation. "
We see posts almost here daily about "... crash ... attach... doesn't work". Granted, many of these
deleted the log file as well, but still. I like to play safe. Yes, I'd appreciate if MS would
provide a technical elaboration about specifically when attach work and when it doesn't. But without
such, I feel that BOL is the one to trust. Especially based on the posts we see here. Even if attach
(without detach) work in 99.99 % of the cases, it isn't good enough for me. Without knowing why it
won't work, I can't trust it. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:ECD839A1-AC24-45BC-94D2-306A82B9397C@.microsoft.com...
> Tibor Im curious about your response. You say he "might" be able to attach,
> what circumstances make this possible?
> "Tibor Karaszi" wrote:
>> You might be able to attach the database files to the new installation. Read about sp_attach_db.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Chris Toffa" <ChrisToffa@.discussions.microsoft.com> wrote in message
>> news:289C92F0-38BF-40DE-B60D-D464F876DBCC@.microsoft.com...
>> > The SBS 2003 server is blue screening. The client has not done any backup in
>> > several months. I have pluged in another HDD, installed Standard 2003 and
>> > then reconnected the old HDD as a second drive. All the data from the old HDD
>> > is now visible and accessible. I can now comfortably recover all their data
>> > except SQL database. Is there any way? Please help. Thanks in advance.
>> >
>> > Chris
>>

Database Recovery

Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.
if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Pleace help me.
Thanks.inter
Do you have a last full backup of the database?
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||As I indicated in my response to your earlier posting (10/27) about the same
issue:
That doesn't sound very good, and since you do NOT have a backup of the
database, it does it sound very hopeful to recover the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||Next time if you don't have UPS backup , Enable Torn Page Detection.
Thanks
Ajay
Arnie Rowland wrote:
> As I indicated in my response to your earlier posting (10/27) about the same
> issue:
> That doesn't sound very good, and since you do NOT have a backup of the
> database, it does it sound very hopeful to recover the 'lost' data.
> You may wish to contact PSS and open a ticket. They 'may' be able to help
> you.
> See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "inter" <halit-goktas.net> wrote in message
> news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> >
> > Can not attach database,
> > Error message;
> > The file you've specified is not a valid SQL Server database file.
> >
> >
> > My costumer HDD some files Deleted mybe elektric prblem -Elektric
> > go,com,go,come- then windows not opened.
> > insert corrupt hdd Another computer, then recovering (recover my files
> > software)
> > Recover mdf and ldf files. but I can not not attach mdf. file,
> >
> >
> > I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> > ok.
> > but my importand table is not ok.
> >
> > if I can recover another recovery software , my database correct recover
> > or
> > same.?
> > I am using RecoverMyFiles.
> >
> > Pleace help me.
> >
> > Thanks.
> >
> >|||Hi,
If your data is critical please contact Microsoft PSS as Arnie suggested...
Thanks
Hari
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>

Sunday, March 11, 2012

Database retains size

Database retains size

Friday, February 24, 2012

database recovery

Database Recovery

database recovery

database recovery

Database Recovery

Database Unit Testing

Blog Archive

About Me