Re: Advice needed

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/29/03

  • Next message: Michelle: "Audit Table" 
    Date: Sun, 28 Dec 2003 19:27:32 -0500

    If your talking about the Sql Server logs then you can use
    sp_cycle_errorlog. 

    -- 
Andrew J. Kelly
SQL Server MVP
"Don Grover" <spamfree@assoft.com.au> wrote in message
news:e$C62CazDHA.1736@TK2MSFTNGP09.phx.gbl...
> I have an sql server db on a remote dedicated server that is open on
> internet, for remote report writing.
> The company that uses is it extremely large and well known, due to this
the
> sql server gets hammered by bogus logins.
> 10,000+ of them a day,.
> Security wise its ok but the bloody error log files are huge 27-48 mb.
>
> Because I logonto this server remotely atleast once a day and check logs,
I
> am finding it difficult  to read them due to the size for vieving log file
> in a TS session.
>
> How can I create 1 error log a day for 7 days then recycle them, or
atleast
> create them into more manageble sizes.
> Regards
> Don
>
>
  • Next message: Michelle: "Audit Table"

    Relevant Pages

    • Re: TS vs VPN
      ... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
      (microsoft.public.windows.terminal_services)
    • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
      ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
      (microsoft.public.sqlserver.dts)
    • Re: Remote Database Connection with PocketPC/MSAccess Front End
      ... If you want to allow direct remote access for your Access data, I'd suggest writing a web service which your remote apps could use. ... The general problem with mobile access to remote data of any kind (including SQL Server which Windows Mobile devices can access directly remotely) is that sometimes the connection just isn't there. ... Generally the easiest backend data store to use for this local cache is going to be SQL Server Compact, which supports several sync strategies including the Access Sync Services that your question isn't about. ...
      (microsoft.public.pocketpc.developer)
    • RE: Login failed for user (null).
      ... used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • RE: CTP3 Failure - Creating a Remote Distributor (error during decrypt
      ... with changes in the SQL Server service account after replication has been set ... Are the remote distributor and the publisher machines in the same domain? ... Are the distributor and publisher SQL Server Service running under domain ...
      (microsoft.public.sqlserver.replication)