I would recommend Ola's solution for backup and specifying the number of files like so : DECLARE INT If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. WITH INIT, NOUNLOAD, NAME = 'DayNite Full Backup', NOSKIP, NOFORMAT) Set = (SELECT ((size*8)/1024)/1000 as SizeGB FROM sys.database_files WHERE file_id = '1') Set =(SELECT CONVERT(char(10), GetDate(),110))ĮXEC _create_subdir broken files for BACKUP DATBASE Function So I have been trying to run the code below but it returns with the following error: I guess is not possible to do it with a FOR or WHILE due to the code in T-SQL. Then: 60 GB / 4 GB = 15 Files for the backup
My objective is to automatically calculate the size of the database and divide it by 4 (4 GB), the result will be the numbers of files of the database.įile Size: 4GB (The size of the multiple files) I'm trying to write an automated script that will allow me to backup the database to a NAS with multiple files.
0 kommentar(er)
