Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2016
    Posts
    19

    Unanswered: How to check SQL Server logs

    Hello,

    We're running some tests on a couple SQL Server instance and we'd like to know if SQL Server has any logs that we can check to see if our tests are working properly.

    What we are trying to test is this: we have an installation application. When we run it, it creates a database in the specified SQL Server instance. We can specify which SQL Server instance it creates this database in as part of the installation procedure. What we want to do is create two SQL Server instance. We want the installation application to create the database in one of them only. The test is to see if there is any impact to the other SQL Server instance. In order to test this, we will need to check the logs associated with that instance.

    Can this be done? And what would we look for in the logs that would tell us that an operation was attempted by the installation application?

  2. #2
    Join Date
    Feb 2006
    Posts
    175
    Provided Answers: 1
    Check out this link about the log files..
    http://sqlmag.com/sql-server/sql-server-log-files

  3. #3
    Join Date
    Dec 2016
    Posts
    19
    Thanks spacebar, that helps half of the way.

    For the other half, what would I look for in the logs to tell that something was attempted on the SQL Server instance by the specific application I'm running?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •