Just a shoot in the dark here...
When SQL Server exports procs to individual files, it creatin them like
dbo.sproc.prc
Needless to say this filename is causing fits...
I've tried to do a rename to no avail
any suggestions?You mean that you don't like the way that Enterprise Mangler names the files produced by SQL-DMO ?!?! You can easily roll your own (http://support.microsoft.com/default.aspx?scid=kb;en-us;233392) if you like, or you can write a short script to rename the bundles of joy delivered by EM. While the rename script is less work, I prefer the roll your own approach myself.
-PatP|||Maybe a better question is who is the file naming causing fits, and why is it causing them those fits ?!?! Maybe I ought to finger out the problem before I start fixin' on it, eh?
-PatP
Showing posts with label filename. Show all posts
Showing posts with label filename. Show all posts
Friday, March 23, 2012
Friday, March 9, 2012
removing logs
I have over 200 log files with a date and timestamp in the filename in the
Reporting Services\LogFiles folder that are 33MB each. This is a development
machine. How do I get rid of them? Can I just delete them?
Thanks,
--
Dan D.You can delete, it creates again, but I dont think you require this much log
files for your development server. For production yes you need to have a
backup. Before deleting keep a backup or Zip all the log files and keep it in
a seperate place.
If it is so important, you can run a program which is available in the
samples to read the log files and reporting.
and ofcourse schedule it to remove. default it keeps it for 60 days.
Amarnath
"Dan D." wrote:
> I have over 200 log files with a date and timestamp in the filename in the
> Reporting Services\LogFiles folder that are 33MB each. This is a development
> machine. How do I get rid of them? Can I just delete them?
> Thanks,
> --
> Dan D.|||I never thought about log files for reportserver. Most of the files are
small, under 50K. I don't know what was in the files that were so large.
I removed them.
Thanks,
--
Dan D.
"Amarnath" wrote:
> You can delete, it creates again, but I dont think you require this much log
> files for your development server. For production yes you need to have a
> backup. Before deleting keep a backup or Zip all the log files and keep it in
> a seperate place.
> If it is so important, you can run a program which is available in the
> samples to read the log files and reporting.
> and ofcourse schedule it to remove. default it keeps it for 60 days.
> Amarnath
> "Dan D." wrote:
> > I have over 200 log files with a date and timestamp in the filename in the
> > Reporting Services\LogFiles folder that are 33MB each. This is a development
> > machine. How do I get rid of them? Can I just delete them?
> >
> > Thanks,
> > --
> > Dan D.
Reporting Services\LogFiles folder that are 33MB each. This is a development
machine. How do I get rid of them? Can I just delete them?
Thanks,
--
Dan D.You can delete, it creates again, but I dont think you require this much log
files for your development server. For production yes you need to have a
backup. Before deleting keep a backup or Zip all the log files and keep it in
a seperate place.
If it is so important, you can run a program which is available in the
samples to read the log files and reporting.
and ofcourse schedule it to remove. default it keeps it for 60 days.
Amarnath
"Dan D." wrote:
> I have over 200 log files with a date and timestamp in the filename in the
> Reporting Services\LogFiles folder that are 33MB each. This is a development
> machine. How do I get rid of them? Can I just delete them?
> Thanks,
> --
> Dan D.|||I never thought about log files for reportserver. Most of the files are
small, under 50K. I don't know what was in the files that were so large.
I removed them.
Thanks,
--
Dan D.
"Amarnath" wrote:
> You can delete, it creates again, but I dont think you require this much log
> files for your development server. For production yes you need to have a
> backup. Before deleting keep a backup or Zip all the log files and keep it in
> a seperate place.
> If it is so important, you can run a program which is available in the
> samples to read the log files and reporting.
> and ofcourse schedule it to remove. default it keeps it for 60 days.
> Amarnath
> "Dan D." wrote:
> > I have over 200 log files with a date and timestamp in the filename in the
> > Reporting Services\LogFiles folder that are 33MB each. This is a development
> > machine. How do I get rid of them? Can I just delete them?
> >
> > Thanks,
> > --
> > Dan D.
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
>
>.
>
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,
>
>.
>
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]
>
>.
>
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]
>
>.
>
Subscribe to:
Posts (Atom)