Determining Security: thus

Showing posts with label thus. Show all posts

Sunday, March 11, 2012

Detaching and Attaching Standby Database

I need to be able to detach my standby database so I can back it up.
How do I reattach it and keep it from going through a recover (thus
breaking my log consistency with the production database)?
I thought about doing a NET STOP MSSQLSERVER, backup files, and NET
START MSSQLSERVER, but I'm not sure if that will work.Brad
Have you read the article in the BOL
"How to set up, maintain, and bring online a standby server (Transact-SQL)"?
"Brad" <brad@.seesigifthere.com> wrote in message
news:MPG.1b7bedee1a217f72989689@.news...
> I need to be able to detach my standby database so I can back it up.
> How do I reattach it and keep it from going through a recover (thus
> breaking my log consistency with the production database)?
> I thought about doing a NET STOP MSSQLSERVER, backup files, and NET
> START MSSQLSERVER, but I'm not sure if that will work.|||In article <#b#zEYueEHA.1036@.TK2MSFTNGP10.phx.gbl>, urid@.iscar.co.il
says...
> "Brad" <brad@.seesigifthere.com> wrote in message
> news:MPG.1b7bedee1a217f72989689@.news...
> > I need to be able to detach my standby database so I can back it up.
> > How do I reattach it and keep it from going through a recover (thus
> > breaking my log consistency with the production database)?
> >
> > I thought about doing a NET STOP MSSQLSERVER, backup files, and NET
> > START MSSQLSERVER, but I'm not sure if that will work.
> Have you read the article in the BOL
> "How to set up, maintain, and bring online a standby server (Transact-SQL)"?
Yes, I've read that and I have all of that working. The problem is that
I really want to just keep restoring logs on this server, but I want to
have a local backup of the standby database (45GB production database is
on the west coast and I am on the east with only a T1 between the two).
Yesterday I had some kind of disk hiccup during a log restore and the
standby database was hosed so I have to go back to a 1.5 week old full
backup and a ton of log restores. If I could just automatically backup
(full) the standby database each night my restore issue would be much
smaller. I understand that I can't do an actual backup, but I should be
able to detach, copy and attach or something like that.|||Brad
I see what you mean
http://www.sql-server-performance.com/sql_server_log_shipping.asp
"Brad" <brad@.seesigifthere.com> wrote in message
news:MPG.1b7bf5b3bb5a904198968a@.news...
> In article <#b#zEYueEHA.1036@.TK2MSFTNGP10.phx.gbl>, urid@.iscar.co.il
> says...
> >
> > "Brad" <brad@.seesigifthere.com> wrote in message
> > news:MPG.1b7bedee1a217f72989689@.news...
> > > I need to be able to detach my standby database so I can back it up.
> > > How do I reattach it and keep it from going through a recover (thus
> > > breaking my log consistency with the production database)?
> > >
> > > I thought about doing a NET STOP MSSQLSERVER, backup files, and NET
> > > START MSSQLSERVER, but I'm not sure if that will work.
> >
> > Have you read the article in the BOL
> > "How to set up, maintain, and bring online a standby server
(Transact-SQL)"?
> Yes, I've read that and I have all of that working. The problem is that
> I really want to just keep restoring logs on this server, but I want to
> have a local backup of the standby database (45GB production database is
> on the west coast and I am on the east with only a T1 between the two).
> Yesterday I had some kind of disk hiccup during a log restore and the
> standby database was hosed so I have to go back to a 1.5 week old full
> backup and a ton of log restores. If I could just automatically backup
> (full) the standby database each night my restore issue would be much
> smaller. I understand that I can't do an actual backup, but I should be
> able to detach, copy and attach or something like that.|||In article <utmHMwueEHA.2908@.TK2MSFTNGP10.phx.gbl>, urid@.iscar.co.il
says...
> "Brad" <brad@.seesigifthere.com> wrote in message
> news:MPG.1b7bf5b3bb5a904198968a@.news...
> > In article <#b#zEYueEHA.1036@.TK2MSFTNGP10.phx.gbl>, urid@.iscar.co.il
> > says...
> > >
> > > "Brad" <brad@.seesigifthere.com> wrote in message
> > > news:MPG.1b7bedee1a217f72989689@.news...
> > > > I need to be able to detach my standby database so I can back it up.
> > > > How do I reattach it and keep it from going through a recover (thus
> > > > breaking my log consistency with the production database)?
> > > >
> > > > I thought about doing a NET STOP MSSQLSERVER, backup files, and NET
> > > > START MSSQLSERVER, but I'm not sure if that will work.
> > >
> > > Have you read the article in the BOL
> > > "How to set up, maintain, and bring online a standby server
> (Transact-SQL)"?
> >
> > Yes, I've read that and I have all of that working. The problem is that
> > I really want to just keep restoring logs on this server, but I want to
> > have a local backup of the standby database (45GB production database is
> > on the west coast and I am on the east with only a T1 between the two).
> > Yesterday I had some kind of disk hiccup during a log restore and the
> > standby database was hosed so I have to go back to a 1.5 week old full
> > backup and a ton of log restores. If I could just automatically backup
> > (full) the standby database each night my restore issue would be much
> > smaller. I understand that I can't do an actual backup, but I should be
> > able to detach, copy and attach or something like that.
> I see what you mean
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
But I can't do real log shipping because I am on standard.

Friday, March 9, 2012

DETACH database gray out

Hi gurus
I try to detached a database but the detach entry is gray out thus I cannot
detach the database.
I am logged in as sa , mssql2000 . Right click on the database -> All tasks
-> Detach database ( Gray out )....
Any idea what is wrong? Why is it gray out?What database are you trying to detach? If it is a system database, you
cannot detach it.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"dezhi" <wushu_kid(NoSpam)@.msn.com> wrote in message
news:FA15395A-8D3A-49C2-98A6-93912DA0C095@.microsoft.com...
> Hi gurus
> I try to detached a database but the detach entry is gray out thus I
> cannot
> detach the database.
> I am logged in as sa , mssql2000 . Right click on the database -> All
> tasks
> -> Detach database ( Gray out )....
> Any idea what is wrong? Why is it gray out?|||On all databases including masters, model and or users databases. On the
other sqlserver instances I have no such issue?!?!?!?
"Kalen Delaney" wrote:
> What database are you trying to detach? If it is a system database, you
> cannot detach it.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "dezhi" <wushu_kid(NoSpam)@.msn.com> wrote in message
> news:FA15395A-8D3A-49C2-98A6-93912DA0C095@.microsoft.com...
> > Hi gurus
> > I try to detached a database but the detach entry is gray out thus I
> > cannot
> > detach the database.
> >
> > I am logged in as sa , mssql2000 . Right click on the database -> All
> > tasks
> > -> Detach database ( Gray out )....
> >
> > Any idea what is wrong? Why is it gray out?
>
>|||Are you sure the instance you are connecting to is a SQL Server 2000
instance?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"dezhi" <wushu_kid(NoSpam)@.msn.com> wrote in message
news:4902C8EF-1179-4BEA-9331-66B8998B6190@.microsoft.com...
> On all databases including masters, model and or users databases. On the
> other sqlserver instances I have no such issue?!?!?!?
> "Kalen Delaney" wrote:
>> What database are you trying to detach? If it is a system database, you
>> cannot detach it.
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "dezhi" <wushu_kid(NoSpam)@.msn.com> wrote in message
>> news:FA15395A-8D3A-49C2-98A6-93912DA0C095@.microsoft.com...
>> > Hi gurus
>> > I try to detached a database but the detach entry is gray out thus I
>> > cannot
>> > detach the database.
>> >
>> > I am logged in as sa , mssql2000 . Right click on the database -> All
>> > tasks
>> > -> Detach database ( Gray out )....
>> >
>> > Any idea what is wrong? Why is it gray out?
>>

Sunday, March 11, 2012

Detaching and Attaching Standby Database

Friday, March 9, 2012

DETACH database gray out

DETACH database gray out

DETACH database gray out

Determining Security

Blog Archive

About Me