Hello All, I need to back up a few databases for a program called Primavera. its connected to MS sql express 2005. I see that in studio manager that you can run a backup but in the express version the backups cant be scheduled.
I saw this command online to back up
which in turn I created this
-- For FULL backup
"BACKUP DATABASE PMDB TO DISK = 'F:\Primavera server backup\Primavera database backup\Full\PMDB.bak'
I created a .bat file so I could schedule it. in my testing it looks like it failed. I happened to go into the directory where the script file resides and I saw this sql log.
"Fatal NI connect error 12560, connecting to:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 31-AUG-2010 16:18:57
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0
im wondering if i DID something wrong in the command or if i couldnt connect to the DB for some reason.
This product also uses ORACLE 10 g for Db connectivity.
I was curious to see if I have incorrect syntax or is my issue larger.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
This article will describe one method to parse a delimited string into a table of data.
Why would I do that you ask? Let's say that you need to pass multiple parameters into a stored procedure to search for. For our sake, we'll say that we wa…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download.
This will be demonstrated using Microsoft Expression Encoder 4.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …