Re: Backup to another drive

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/14/03

  • Next message: kbramey: "SQL user losing right to log in service"
    Date: Mon, 14 Jul 2003 11:14:37 -0400
    
    

    And make sure the device is not opened by something else such as a tape
    backup agent.

    -- 
    Andrew J. Kelly
    SQL Server MVP
    "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
    news:OZsncrgSDHA.2676@TK2MSFTNGP10.phx.gbl...
    > You might check the SQL Server error log to see if additional
    > information (error code) is returned.
    >
    > -- 
    > Hope this helps.
    >
    > Dan Guzman
    > SQL Server MVP
    >
    > -----------------------
    > SQL FAQ links (courtesy  Neil Pike):
    >
    > http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
    > http://www.sqlserverfaq.com
    > http://www.mssqlserver.com/faq
    > -----------------------
    >
    > "Phil Grubb" <philip.grubb@cigna.com> wrote in message
    > news:eOfJqkgSDHA.2084@TK2MSFTNGP11.phx.gbl...
    > >
    > > HI Andrew
    > > Thanks for your reply
    > >
    > > I have restarted SQLServer so that it runs from my own user acount
    > which
    > > is set up inthe domain as the administrator for both servers and as
    > the
    > > owner for the file.
    > >
    > > Any ideas?
    > >
    > > *** Sent via Developersdex http://www.developersdex.com ***
    > > Don't just participate in USENET...get rewarded for it!
    >
    >
    

  • Next message: kbramey: "SQL user losing right to log in service"

    Relevant Pages

    • Re: reindex or update stat
      ... update statistics turned on sql server should deal with it appropriately. ... Andrew J. Kelly ... SQL Server MVP ... I set up the Maintenance Plan to have Optimizations to ...
      (microsoft.public.sqlserver.server)
    • Re: High Throughput Database
      ... First column. ... Tibor Karaszi, SQL Server MVP ... "Dan Guzman" wrote in message ...
      (microsoft.public.sqlserver.programming)
    • Re: Index and Begin With search
      ... Sql Server will have to scan the table either way. ... Andrew J. Kelly ... > My second question is not related to indexed colums. ... >> SQL Server MVP ...
      (microsoft.public.sqlserver.programming)
    • Re: Corrupted Record
      ... >>Andrew J. Kelly ... >>SQL Server MVP ... >>> Enterprise Manager to freeze and I have to bring up ...
      (microsoft.public.sqlserver.setup)
    • Re: Database grew 50% in a week ???
      ... Thanks Andrew. ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ... >>>> Andrew J. Kelly SQL MVP ...
      (microsoft.public.sqlserver.tools)