Full and Differential Backup T-SQL
Posted on 2010-08-31
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.