Once replicated DB can't be detached

Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the db?
Many thanks!
Henry
Try this:
EXEC sp_dboption 'DBNameHere', 'published', 'false'
GO
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the
db?
Many thanks!
Henry
|||Thanks!
"Narayana Vyas Kondreddi" wrote:

> Try this:
> EXEC sp_dboption 'DBNameHere', 'published', 'false'
> GO
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Henry" <Henry@.discussions.microsoft.com> wrote in message
> news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
> Dear Sir,
> I have a database which has been "Transactional" replicated one table. I
> already deleted the subscription and deleted the publication. But still the
> database has the replicate icon besides on EM and not allowing me to detach.
> What can I do to refresh the DB status in order to allow me to detach the
> db?
> Many thanks!
> Henry
>
>

Once replicated DB can't be detached

Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the db
?
Many thanks!
HenryTry this:
EXEC sp_dboption 'DBNameHere', 'published', 'false'
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the
db?
Many thanks!
Henry|||Thanks!
"Narayana Vyas Kondreddi" wrote:

> Try this:
> EXEC sp_dboption 'DBNameHere', 'published', 'false'
> GO
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Henry" <Henry@.discussions.microsoft.com> wrote in message
> news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
> Dear Sir,
> I have a database which has been "Transactional" replicated one table. I
> already deleted the subscription and deleted the publication. But still th
e
> database has the replicate icon besides on EM and not allowing me to detac
h.
> What can I do to refresh the DB status in order to allow me to detach the
> db?
> Many thanks!
> Henry
>
>sql

Once replicated DB can't be detached

Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the db?
Many thanks!
HenryTry this:
EXEC sp_dboption 'DBNameHere', 'published', 'false'
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
Dear Sir,
I have a database which has been "Transactional" replicated one table. I
already deleted the subscription and deleted the publication. But still the
database has the replicate icon besides on EM and not allowing me to detach.
What can I do to refresh the DB status in order to allow me to detach the
db?
Many thanks!
Henry|||Thanks!
"Narayana Vyas Kondreddi" wrote:
> Try this:
> EXEC sp_dboption 'DBNameHere', 'published', 'false'
> GO
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Henry" <Henry@.discussions.microsoft.com> wrote in message
> news:9DB717B5-CCE8-41B8-A7CC-15E422F750E1@.microsoft.com...
> Dear Sir,
> I have a database which has been "Transactional" replicated one table. I
> already deleted the subscription and deleted the publication. But still the
> database has the replicate icon besides on EM and not allowing me to detach.
> What can I do to refresh the DB status in order to allow me to detach the
> db?
> Many thanks!
> Henry
>
>

Old, deleted Identity values re-used?

If I have an Identity-declared column, the table has lots of rows and I start deleteting records - will any old, deleted identities be re-used (without an explicit re-seed) ?
(I'm talking about numerical Identities, not these GUID things)No. Not without manipulating the IDENTITY column. The exception being that if you TRUNCATE the table, then the seed will reset to the floor value.

Regards,

hmscott|||yeah,it can be used
need to set identity off
insert statement
reset identity on

Old Backups not being deleted

We are having a consistent problem here with the archived backups not being
deleted like is defined in the maintenance plans.
We have the maintenance plan set to backup all user databases and keep the
past 7 days worth. But after the 7th day it is NOT deleting the older
backups. So the first time we found this out was when the server ran out of
disk space and we found a full months worth of backups in the SQL Server
backup directory!
Any idea why this is happen and how to fix it so that maint plan works as
its being told to work?
Thanks,
John Gundrum
There are some knowledge base articles regarding this issue. Have you checked
those? One of them refers to the transaction log backup being part of the
plan but one of the databases being backed up having SIMPLE as the recovery
method.
"John Gundrum" wrote:

> We are having a consistent problem here with the archived backups not being
> deleted like is defined in the maintenance plans.
> We have the maintenance plan set to backup all user databases and keep the
> past 7 days worth. But after the 7th day it is NOT deleting the older
> backups. So the first time we found this out was when the server ran out of
> disk space and we found a full months worth of backups in the SQL Server
> backup directory!
> Any idea why this is happen and how to fix it so that maint plan works as
> its being told to work?
> Thanks,
> John Gundrum
|||Yes, we've looked into that and the transaction log is not part of the plan.
The back plan has been recreated once again for the user databases and we'll
start to see if old backups are being deleted later this week.
John Gundrum
"Charles Allen" wrote:
[vbcol=seagreen]
> There are some knowledge base articles regarding this issue. Have you checked
> those? One of them refers to the transaction log backup being part of the
> plan but one of the databases being backed up having SIMPLE as the recovery
> method.
> "John Gundrum" wrote:

Old Backups not being deleted

We are having a consistent problem here with the archived backups not being
deleted like is defined in the maintenance plans.
We have the maintenance plan set to backup all user databases and keep the
past 7 days worth. But after the 7th day it is NOT deleting the older
backups. So the first time we found this out was when the server ran out of
disk space and we found a full months worth of backups in the SQL Server
backup directory!
Any idea why this is happen and how to fix it so that maint plan works as
its being told to work?
Thanks,
John Gundrum
> Any idea why this is happen and how to fix it so that maint plan works as
> its being told to work?
I had maintenance plans set up to delete backups more than two days old, and
it was leaving 4 or 5 days, depending on if it was over the weekend or not.
I've heard many reports of maintenance plans having similarly weird
behavior.
Instead of trying to investigate and fix the nonsense, I wrote a standalone
app that deleted backups older than 2 days.
|||Take a look at:
BUG: Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan
http://support.microsoft.com/default...&Product=sql2k
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Aaron [SQL Server MVP]" wrote:

> I had maintenance plans set up to delete backups more than two days old, and
> it was leaving 4 or 5 days, depending on if it was over the weekend or not.
> I've heard many reports of maintenance plans having similarly weird
> behavior.
> Instead of trying to investigate and fix the nonsense, I wrote a standalone
> app that deleted backups older than 2 days.
>
>

Old Backups not being deleted

We are having a consistent problem here with the archived backups not being
deleted like is defined in the maintenance plans.
We have the maintenance plan set to backup all user databases and keep the
past 7 days worth. But after the 7th day it is NOT deleting the older
backups. So the first time we found this out was when the server ran out of
disk space and we found a full months worth of backups in the SQL Server
backup directory!
Any idea why this is happen and how to fix it so that maint plan works as
its being told to work?
Thanks,
John Gundrum> Any idea why this is happen and how to fix it so that maint plan works as
> its being told to work?
I had maintenance plans set up to delete backups more than two days old, and
it was leaving 4 or 5 days, depending on if it was over the weekend or not.
I've heard many reports of maintenance plans having similarly weird
behavior.
Instead of trying to investigate and fix the nonsense, I wrote a standalone
app that deleted backups older than 2 days.|||Take a look at:
BUG: Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan
http://support.microsoft.com/default.aspx?scid=kb;en-us;303292&Product=sql2k
--
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Aaron [SQL Server MVP]" wrote:
> > Any idea why this is happen and how to fix it so that maint plan works as
> > its being told to work?
> I had maintenance plans set up to delete backups more than two days old, and
> it was leaving 4 or 5 days, depending on if it was over the weekend or not.
> I've heard many reports of maintenance plans having similarly weird
> behavior.
> Instead of trying to investigate and fix the nonsense, I wrote a standalone
> app that deleted backups older than 2 days.
>
>

Old Backups not being deleted

We are having a consistent problem here with the archived backups not being
deleted like is defined in the maintenance plans.
We have the maintenance plan set to backup all user databases and keep the
past 7 days worth. But after the 7th day it is NOT deleting the older
backups. So the first time we found this out was when the server ran out of
disk space and we found a full months worth of backups in the SQL Server
backup directory!
Any idea why this is happen and how to fix it so that maint plan works as
its being told to work?
Thanks,
John Gundrum> Any idea why this is happen and how to fix it so that maint plan works as
> its being told to work?
I had maintenance plans set up to delete backups more than two days old, and
it was leaving 4 or 5 days, depending on if it was over the weekend or not.
I've heard many reports of maintenance plans having similarly weird
behavior.
Instead of trying to investigate and fix the nonsense, I wrote a standalone
app that deleted backups older than 2 days.|||Take a look at:
BUG: Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan
http://support.microsoft.com/defaul...2&Product=sql2k
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Aaron [SQL Server MVP]" wrote:

> I had maintenance plans set up to delete backups more than two days old, a
nd
> it was leaving 4 or 5 days, depending on if it was over the weekend or not
.
> I've heard many reports of maintenance plans having similarly weird
> behavior.
> Instead of trying to investigate and fix the nonsense, I wrote a standalon
e
> app that deleted backups older than 2 days.
>
>

Old backups are not deleted

Hi guys,
I find out that if you use DMP and change the backup path from default and
set the settings to delete old backup , say after 3 days, it doesnt really
delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as
well as in SQL2005
TIAWait one more day, you need to check the clock it will delte it on the 4th
day only. We are also using DMP and specified "Use This Directory",
Remove files older that 3 days , and provided "backup file extension" as
"BAK" same as i provided for backup's... You have not mentioned that in you
r
configuration list. Try "backup file extension" and see. Let me know if it
works? Check MSSQL/ErrorLog also and see if there is something unusal.
Thanks,
Sree
"rupart" wrote:

> Hi guys,
> I find out that if you use DMP and change the backup path from default and
> set the settings to delete old backup , say after 3 days, it doesnt really
> delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 a
s
> well as in SQL2005
>
> TIA|||hi Sreejit,
Yes i have specified .bak or .trn. But i saw there are files more than 4
days. SOme are even 1 mth back. CLose to the day we started to backup.
"Sreejith G" wrote:
[vbcol=seagreen]
> Wait one more day, you need to check the clock it will delte it on the 4th
> day only. We are also using DMP and specified "Use This Directory",
> Remove files older that 3 days , and provided "backup file extension" as
> "BAK" same as i provided for backup's... You have not mentioned that in y
our
> configuration list. Try "backup file extension" and see. Let me know if it
> works? Check MSSQL/ErrorLog also and see if there is something unusal.
> Thanks,
> Sree
>
> "rupart" wrote:
>

Old backups are not deleted

Hi guys,
I find out that if you use DMP and change the backup path from default and
set the settings to delete old backup , say after 3 days, it doesnt really
delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as
well as in SQL2005
TIA
Wait one more day, you need to check the clock it will delte it on the 4th
day only. We are also using DMP and specified "Use This Directory",
Remove files older that 3 days , and provided "backup file extension" as
"BAK" same as i provided for backup's... You have not mentioned that in your
configuration list. Try "backup file extension" and see. Let me know if it
works? Check MSSQL/ErrorLog also and see if there is something unusal.
Thanks,
Sree
"rupart" wrote:

> Hi guys,
> I find out that if you use DMP and change the backup path from default and
> set the settings to delete old backup , say after 3 days, it doesnt really
> delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as
> well as in SQL2005
>
> TIA
|||hi Sreejit,
Yes i have specified .bak or .trn. But i saw there are files more than 4
days. SOme are even 1 mth back. CLose to the day we started to backup.
"Sreejith G" wrote:
[vbcol=seagreen]
> Wait one more day, you need to check the clock it will delte it on the 4th
> day only. We are also using DMP and specified "Use This Directory",
> Remove files older that 3 days , and provided "backup file extension" as
> "BAK" same as i provided for backup's... You have not mentioned that in your
> configuration list. Try "backup file extension" and see. Let me know if it
> works? Check MSSQL/ErrorLog also and see if there is something unusal.
> Thanks,
> Sree
>
> "rupart" wrote:

Old backups are not deleted

Hi guys,
I find out that if you use DMP and change the backup path from default and
set the settings to delete old backup , say after 3 days, it doesnt really
delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as
well as in SQL2005
TIAWait one more day, you need to check the clock it will delte it on the 4th
day only. We are also using DMP and specified "Use This Directory",
Remove files older that 3 days , and provided "backup file extension" as
"BAK" same as i provided for backup's... You have not mentioned that in your
configuration list. Try "backup file extension" and see. Let me know if it
works? Check MSSQL/ErrorLog also and see if there is something unusal.
Thanks,
Sree
"rupart" wrote:
> Hi guys,
> I find out that if you use DMP and change the backup path from default and
> set the settings to delete old backup , say after 3 days, it doesnt really
> delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as
> well as in SQL2005
>
> TIA|||hi Sreejit,
Yes i have specified .bak or .trn. But i saw there are files more than 4
days. SOme are even 1 mth back. CLose to the day we started to backup.
"Sreejith G" wrote:
> Wait one more day, you need to check the clock it will delte it on the 4th
> day only. We are also using DMP and specified "Use This Directory",
> Remove files older that 3 days , and provided "backup file extension" as
> "BAK" same as i provided for backup's... You have not mentioned that in your
> configuration list. Try "backup file extension" and see. Let me know if it
> works? Check MSSQL/ErrorLog also and see if there is something unusal.
> Thanks,
> Sree
>
> "rupart" wrote:
> > Hi guys,
> > I find out that if you use DMP and change the backup path from default and
> > set the settings to delete old backup , say after 3 days, it doesnt really
> > delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as
> > well as in SQL2005
> >
> >
> > TIA