Start a Conversation

jsallila

updated

18 years ago

Solved!

Go to Solution
J

jsallila

56 Posts

0

613

February 11th, 2009 03:00

Multiple SQL instances on same server. How to backup?

I have new wíndows 2003 host which have two separate SQL instances installed.

When I start the NW SQL gui it prompts which instance i want to work with like this:

SIM01
SIM01\\WEBDB

How can I create scheduled backup for SIM01\\WEBDB-instance. If I use normal nsrsqlsv and saveset MSSQL:, only instance SIM01 is backed up.

NW version 7.22 and NMSQL 5.0sp1
  • B

    ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    322

    0

    Posted February 11th, 2009 04:00

    You should check docs for correct syntax, but something like MSSLQ$SIM01:WEBDB could do the trick... When you run his from GUI on client check for syntax used and then use that to build scheduled client resource.
  • H

    Hari5

    443 Posts

    322

    0

    Posted February 11th, 2009 05:00

    I am pretty sure the syntax is MSSQL:SIM01\WEBDB As Hrvoje mentioned, check the admin guide for the SQL module to make sure.
  • J

    jsallila

    56 Posts

    322

    0

    Posted February 11th, 2009 23:00

    Correct syntax is MSSQL$WEBDB:

    Checking the applogs after host initiated backup was great idea. Thanks.

Dell Support Resources

Latest Solutions

View More