Solved

Sqllib Error

Posted on 2004-11-01
906 Views
Last Modified: 2008-02-01
source VSS event id 6004

Sqllib error: Database db489 is not simple.

this appears on my sql server. thing is i dont know what it means, database is still running

any help would be cool

cheers mark
0
Question by:mleman
    3 Comments
     
    LVL 8

    Expert Comment

    by:SashP
    Hi mleman

    Does this happen when you are trying to restore the database?  If not what action if any is being undertaken?  

    Cheers Sash
    0
     
    LVL 5

    Author Comment

    by:mleman
    Hi Sashp,

    its when its backedup

    backup database db489 to db489store
    0
     
    LVL 8

    Accepted Solution

    by:
    You are using NT Backup ?

    Open SQL Manager and go to the properties of your database. Go to the options tab and make sure the recovery type is set to simple.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Cisco Complete Network Certification Training

    If you’re an IT engineer or technician, it's time you take your career to the next level. This elite training bundle is brimming with all of the information you need to learn to sit for Cisco CNNA, CCNP, and CCENT certification exams.

    SQL Server Side Trace is a technique of Profiling SQL Server Events Silently (i.e without Using the Profiling Tool). Running a visual tool in production increases overhead, but we can develop server side Trace using Sql Server Profiler itself. We…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now