I'm quite new to SQL Server and some employee asked me if is possible to make monthly database backups.
We do daily full backups to NAS server via Cobian and we use SQL Server Management Studio to make maintenance plan for daily full backup as well.
My problem is that the database that I want to make the monthly backup is used by a software that is not developed by us so I have no clue how to make queries to extract data from date types, etc. The database has a lot of tables.
All I want is to extract data from January only and make a backup with January data only so i can send to external company. Is that even possible without T-SQL queries?