Multiple SQL instances on same server. How to backup?

Question

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

ble1 · Accepted Answer

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.

Hari5 · Answer

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

jsallila · Answer

Correct syntax is MSSQL$WEBDB:Checking the applogs after host initiated backup was great idea. Thanks.

NetWorker

Multiple SQL instances on same server. How to backup?

Was this post helpful?