Showing posts with label own. Show all posts
Showing posts with label own. Show all posts

Monday, March 12, 2012

removing replication on SP

I have my own SP in the master database that had sp_MS_marksystemobject applied to it. It now needs revising but it cannot be renamed. It cannot be dropped because it is used for replication (apparently).
When I try to drop it, get message: Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the procedure '<sp_name>' because it is being used for replication.
Anyone know how the replication can be removed
use sp_MSunmarkreplinfo against this proc and then drop it from within isqlw.

Monday, February 20, 2012

Removing Backups

Hello,
We do our own backups i.e.
Where filename is the name of the database with a
timestamp.
EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
Backup database ParisTestProduction to @.FileName.
Is there a safe way to remove the backup history and file,
or will I need to write one.
BTW we cannot use the 'Database Maintenance Plan'
thanks for your help
Peterto remove backup history try sp_delete_backuphistory
to delete your old backup probably you must write script
mous@.discussions.microsoft.com> wrote in message
news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
> Hello,
> We do our own backups i.e.
> Where filename is the name of the database with a
> timestamp.
> EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
> Backup database ParisTestProduction to @.FileName.
> Is there a safe way to remove the backup history and file,
> or will I need to write one.
> BTW we cannot use the 'Database Maintenance Plan'
> thanks for your help
> Peter|||Thank you
Peter
>--Original Message--
>to remove backup history try sp_delete_backuphistory
>to delete your old backup probably you must write script
>mous@.discussions.microsoft.com> wrote in message
>news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
>> Hello,
>> We do our own backups i.e.
>> Where filename is the name of the database with a
>> timestamp.
>> EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
>> Backup database ParisTestProduction to @.FileName.
>> Is there a safe way to remove the backup history and
file,
>> or will I need to write one.
>> BTW we cannot use the 'Database Maintenance Plan'
>> thanks for your help
>> Peter
>
>.
>

Removing Backups

Hello,
We do our own backups i.e.
Where filename is the name of the database with a
timestamp.
EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
Backup database ParisTestProduction to @.FileName.
Is there a safe way to remove the backup history and file,
or will I need to write one.
BTW we cannot use the 'Database Maintenance Plan'
thanks for your help
Peter
to remove backup history try sp_delete_backuphistory
to delete your old backup probably you must write script
mous@.discussions.microsoft.com> wrote in message
news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
> Hello,
> We do our own backups i.e.
> Where filename is the name of the database with a
> timestamp.
> EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
> Backup database ParisTestProduction to @.FileName.
> Is there a safe way to remove the backup history and file,
> or will I need to write one.
> BTW we cannot use the 'Database Maintenance Plan'
> thanks for your help
> Peter
|||Thank you
Peter
[vbcol=seagreen]
>--Original Message--
>to remove backup history try sp_delete_backuphistory
>to delete your old backup probably you must write script
>mous@.discussions.microsoft.com> wrote in message
>news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
file,
>
>.
>

Removing Backups

Hello,
We do our own backups i.e.
Where filename is the name of the database with a
timestamp.
EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
Backup database ParisTestProduction to @.FileName.
Is there a safe way to remove the backup history and file,
or will I need to write one.
BTW we cannot use the 'Database Maintenance Plan'
thanks for your help
Peterto remove backup history try sp_delete_backuphistory
to delete your old backup probably you must write script
mous@.discussions.microsoft.com> wrote in message
news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
> Hello,
> We do our own backups i.e.
> Where filename is the name of the database with a
> timestamp.
> EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
> Backup database ParisTestProduction to @.FileName.
> Is there a safe way to remove the backup history and file,
> or will I need to write one.
> BTW we cannot use the 'Database Maintenance Plan'
> thanks for your help
> Peter|||Thank you
Peter

>--Original Message--
>to remove backup history try sp_delete_backuphistory
>to delete your old backup probably you must write script
>mous@.discussions.microsoft.com> wrote in message
>news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
file,[vbcol=seagreen]
>
>.
>