Post reply

sql server stops

  • March 2, 2006 at 7:56 am

    #189545

     

    We are backing up SQL server to tape so the sql service is being stopped by a backup script on the sql server host.

    At the end of the backup the sql service is restarted by the script and everything is running like normal, I THINK!

    But when we browse to a website we get the following "SQL server does not exist or access denied" and this is only fixed when we reboot the server.

    Anyone come across this before?

  • March 2, 2006 at 1:45 pm

    #624463

    Sounds like SQL Server service isn't getting restarted.

    It's really better to back up SQL to disk, then back up that file to disk, rather than backing up directly to tape.  The backup will be faster and there's no need to stop the service.

  • March 3, 2006 at 1:35 am

    #624544

    Thanks for the reply.

    As I know zero about sql except that I have to solve this problem, I am going to ask a question that probably is stupid, but here goes.

    Are you saying that the database can still be accessed while it is being backed up to disk, and be backed up while in use?

    Or does it mean that a particular db in use will be not be backed up if it is in use when a backup request comes in for it?

    Thanks

    R

  • March 3, 2006 at 5:56 am

    #624566

    You can backup a SQL database while it is in use.   For best results and to check how much of a performance degradation you see, you probably want to try running a backup while the db is live (but not necessarily at a peak time of usage).

     

     

    Have a good day,

    Norene Malaney

  • March 3, 2006 at 6:12 am

    #624570

    Yeah, sorry I wasn't clear with my first post.  There's no need to stop SQL to perform a backup.  As Norene points out you want to do this during your lowest usage time.

    Backup tips: http://www.sql-server-performance.com/backup_restore_tuning.asp

     

  • March 3, 2006 at 7:08 am

    #624594

    Thanks Noreen and Joe, I have now modified my backup script and will try it with no service stop or backup to tape - just to another disk.

    Thanks again  

    Roger

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply