SQL DATABASE BACK UP TO QNAP(TS-x53Be Series)

Introduce yourself to us and other members here, or share your own product reviews, suggestions, and tips and tricks of using QNAP products.
Post Reply
ayotade
New here
Posts: 3
Joined: Wed Jun 17, 2020 5:23 pm

SQL DATABASE BACK UP TO QNAP(TS-x53Be Series)

Post by ayotade »

Both QNaP and SQL server are on the same network and I have successfully mapped Qnap(map network drive) to the SQL server.
I want to set up a regular back up of the database(s) directly from SQL server to QNAP and not the server. When trying to do this, only local drivers show as paths where I can back up.

So in summary, I want to back up SQL database to Qnap. Please how do I go about this?
User avatar
dolbyman
Guru
Posts: 35248
Joined: Sat Feb 12, 2011 2:11 am
Location: Vancouver BC , Canada

Re: SQL DATABASE BACK UP TO QNAP(TS-x53Be Series)

Post by dolbyman »

unclear what os version the sql is installed on

write a script that dumps the backup to a folder on the qnap (unc path)
ayotade
New here
Posts: 3
Joined: Wed Jun 17, 2020 5:23 pm

Re: SQL DATABASE BACK UP TO QNAP(TS-x53Be Series)

Post by ayotade »

Thank you for for your response dolbyman. I want to backup directly to qnap from sql server.
User avatar
dolbyman
Guru
Posts: 35248
Joined: Sat Feb 12, 2011 2:11 am
Location: Vancouver BC , Canada

Re: SQL DATABASE BACK UP TO QNAP(TS-x53Be Series)

Post by dolbyman »

read my question again....that is not what I asked
ayotade
New here
Posts: 3
Joined: Wed Jun 17, 2020 5:23 pm

Re: SQL DATABASE BACK UP TO QNAP(TS-x53Be Series)

Post by ayotade »

The SQL server is installed on windows 2008 R2 Standard
User avatar
dolbyman
Guru
Posts: 35248
Joined: Sat Feb 12, 2011 2:11 am
Location: Vancouver BC , Canada

Re: SQL DATABASE BACK UP TO QNAP(TS-x53Be Series)

Post by dolbyman »

if it is a MSSQL, just backup the database (bak)

in destination just type in

\\NASNAMEORIP\share\folder\backupname.bak

and the backup should work fine
Post Reply

Return to “Users' Corner”