Disk Full of transactions log's

Hi,
One of my app servers has filled the c:\ drive with transactions log's.
Someone moved the log's to another disk, SQL now reports the database as
being suspect. We moved the log's back, it still reports the db as suspect?
Any help would be greatly appreciated
Rich
Hi,
take a look here:
http://www.karaszi.com/SQLServer/inf...suspect_db.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||reset should resolve the problem (order in sequences, try the next step
if the first one doesn't work).
1) restart the MSSQL services (starts the auto recovery)
2) detach and re-attach the database
3) restore the latest database backup
Mel

Disaster recovery

How to protect the transaction logs from disaster considering the loss
of hardware mirror? Can we use remote mirror for these files?
tram,
Back them up frequently, say every 5 mins? You can also deploy log shipping:
http://msdn.microsoft.com/library/de...erver_8elj.asp
Do you have redundancy at the disk level? Have you implemented a raid array?
RAID-1 is commonly used for transaction log protection - this cannot be used
remotely though, it is local to the server.
See:
http://www.acnc.com/04_01_01_flash.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404211702.2fbb4462@.posting.google.c om...
> How to protect the transaction logs from disaster considering the loss
> of hardware mirror? Can we use remote mirror for these files?
|||What if RAID 1 crashes or on fire? Oracle has got redo groups where
you can place on REDO group in local and other in SAN. Sql
serverdoesn't have this functionality and we lose the data in active
redo . Log shipping doesn't meet our requirement.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> tram,
> Back them up frequently, say every 5 mins? You can also deploy log shipping:
> http://msdn.microsoft.com/library/de...erver_8elj.asp
> Do you have redundancy at the disk level? Have you implemented a raid array?
> RAID-1 is commonly used for transaction log protection - this cannot be used
> remotely though, it is local to the server.
> See:
> http://www.acnc.com/04_01_01_flash.html
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0404211702.2fbb4462@.posting.google.c om...
|||tram,
I'm not familiar with REDO groups. If you are using a SAN, then you could
use the SAN replication functionality to replicate the SQL Server data.
Which SAN vendor are you using? I know this is possible with EMC SRDF and
also Hitachi Data Systems TrueCopy.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404230248.78fefeb1@.posting.google.c om...
> What if RAID 1 crashes or on fire? Oracle has got redo groups where
> you can place on REDO group in local and other in SAN. Sql
> serverdoesn't have this functionality and we lose the data in active
> redo . Log shipping doesn't meet our requirement.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
shipping:[vbcol=seagreen]
http://msdn.microsoft.com/library/de...erver_8elj.asp[vbcol=seagreen]
array?[vbcol=seagreen]
used[vbcol=seagreen]

Disaster recovery

How to protect the transaction logs from disaster considering the loss
of hardware mirror? Can we use remote mirror for these files?tram,
Back them up frequently, say every 5 mins? You can also deploy log shipping:
http://msdn.microsoft.com/library/d...>
ver_8elj.asp
Do you have redundancy at the disk level? Have you implemented a raid array?
RAID-1 is commonly used for transaction log protection - this cannot be used
remotely though, it is local to the server.
See:
http://www.acnc.com/04_01_01_flash.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> How to protect the transaction logs from disaster considering the loss
> of hardware mirror? Can we use remote mirror for these files?|||What if RAID 1 crashes or on fire? Oracle has got redo groups where
you can place on REDO group in local and other in SAN. Sql
serverdoesn't have this functionality and we lose the data in active
redo . Log shipping doesn't meet our requirement.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message news:<e41kfnEKEHA.2716@.tk2ms
ftngp13.phx.gbl>...[vbcol=seagreen]
> tram,
> Back them up frequently, say every 5 mins? You can also deploy log shippin
g:
> http://msdn.microsoft.com/library/d...
erver_8elj.asp
> Do you have redundancy at the disk level? Have you implemented a raid arra
y?
> RAID-1 is commonly used for transaction log protection - this cannot be us
ed
> remotely though, it is local to the server.
> See:
> http://www.acnc.com/04_01_01_flash.html
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0404211702.2fbb4462@.posting.google.com...|||tram,
I'm not familiar with REDO groups. If you are using a SAN, then you could
use the SAN replication functionality to replicate the SQL Server data.
Which SAN vendor are you using? I know this is possible with EMC SRDF and
also Hitachi Data Systems TrueCopy.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404230248.78fefeb1@.posting.google.com...
> What if RAID 1 crashes or on fire? Oracle has got redo groups where
> you can place on REDO group in local and other in SAN. Sql
> serverdoesn't have this functionality and we lose the data in active
> redo . Log shipping doesn't meet our requirement.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
shipping:[vbcol=seagreen]
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp[/ur
l][vbcol=seagreen]
array?[vbcol=seagreen]
used[vbcol=seagreen]

Disaster recovery

How to protect the transaction logs from disaster considering the loss
of hardware mirror? Can we use remote mirror for these files?My server stuff is a bit rusty but I don't believe you can
have a remote mirror, mainly due to network traffic.
Have you though of backing up your database (files and
logs) onto a different server.
J
>--Original Message--
>How to protect the transaction logs from disaster
considering the loss
>of hardware mirror? Can we use remote mirror for these
files?
>.
>|||tram,
Back them up frequently, say every 5 mins? You can also deploy log shipping:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
Do you have redundancy at the disk level? Have you implemented a raid array?
RAID-1 is commonly used for transaction log protection - this cannot be used
remotely though, it is local to the server.
See:
http://www.acnc.com/04_01_01_flash.html
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> How to protect the transaction logs from disaster considering the loss
> of hardware mirror? Can we use remote mirror for these files?|||What if RAID 1 crashes or on fire? Oracle has got redo groups where
you can place on REDO group in local and other in SAN. Sql
serverdoesn't have this functionality and we lose the data in active
redo . Log shipping doesn't meet our requirement.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...
> tram,
> Back them up frequently, say every 5 mins? You can also deploy log shipping:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
> Do you have redundancy at the disk level? Have you implemented a raid array?
> RAID-1 is commonly used for transaction log protection - this cannot be used
> remotely though, it is local to the server.
> See:
> http://www.acnc.com/04_01_01_flash.html
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "tram" <tram_e@.hotmail.com> wrote in message
> news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> > How to protect the transaction logs from disaster considering the loss
> > of hardware mirror? Can we use remote mirror for these files?|||tram,
I'm not familiar with REDO groups. If you are using a SAN, then you could
use the SAN replication functionality to replicate the SQL Server data.
Which SAN vendor are you using? I know this is possible with EMC SRDF and
also Hitachi Data Systems TrueCopy.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"tram" <tram_e@.hotmail.com> wrote in message
news:26ee1067.0404230248.78fefeb1@.posting.google.com...
> What if RAID 1 crashes or on fire? Oracle has got redo groups where
> you can place on REDO group in local and other in SAN. Sql
> serverdoesn't have this functionality and we lose the data in active
> redo . Log shipping doesn't meet our requirement.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:<e41kfnEKEHA.2716@.tk2msftngp13.phx.gbl>...
> > tram,
> >
> > Back them up frequently, say every 5 mins? You can also deploy log
shipping:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
> >
> > Do you have redundancy at the disk level? Have you implemented a raid
array?
> > RAID-1 is commonly used for transaction log protection - this cannot be
used
> > remotely though, it is local to the server.
> >
> > See:
> > http://www.acnc.com/04_01_01_flash.html
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> >
> >
> >
> > "tram" <tram_e@.hotmail.com> wrote in message
> > news:26ee1067.0404211702.2fbb4462@.posting.google.com...
> > > How to protect the transaction logs from disaster considering the loss
> > > of hardware mirror? Can we use remote mirror for these files?