This post is more than 5 years old
142 Posts
0
2227
Unable to Backup SQL Database, error: MSSQL:: No such file or directory
Hi,
I am comfiguring backup for SQL 1st time.
Iam getting following error :
MSSQL:: No such file or directory
The Client is having MS SQL Module Installed
I am able to backup Database From Client Windows, but not through Networker Server.
Networker Version : 7.5
SQL Agent Version : 5.2
Save Set : MSSQL:
Client : Windows Server 2003
MS SQL Version : MS SQL 2005
Please Help!
Thanks in Advance!
.::[ashX]::.
I am comfiguring backup for SQL 1st time.
Iam getting following error :
MSSQL:: No such file or directory
The Client is having MS SQL Module Installed
I am able to backup Database From Client Windows, but not through Networker Server.
Networker Version : 7.5
SQL Agent Version : 5.2
Save Set : MSSQL:
Client : Windows Server 2003
MS SQL Version : MS SQL 2005
Please Help!
Thanks in Advance!
.::[ashX]::.
ble1
2 Intern
2 Intern
•
14.3K Posts
0
March 27th, 2009 05:00
Also, your description is a bit poor - you may wish to post full description like what databases are not backed up and full log by module which you will find in applogs folder on application host.
ashxos
142 Posts
0
March 27th, 2009 05:00
ble1
2 Intern
2 Intern
•
14.3K Posts
1
March 27th, 2009 05:00
ashxos
142 Posts
0
March 27th, 2009 05:00
What will be the reason?
I am using the Backup Command : nsrsqlsv -v
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
March 27th, 2009 15:00
if you have a named instance, specify saveset: MSSQL$(instance_name):
To back up a database in the named instance, specify saveset: MSSQL$(instance_name):(database name)
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
March 30th, 2009 19:00
in order to backup a SQL databse successfully
take a copy of NSR saveset syntax from manual backup "same structure"
update client defenition with this particular saveset
ashxos
142 Posts
0
March 31st, 2009 00:00
Those were not attached, they were just laying their as a file...
Because of that it must be doing so...