SQL SERVER AUTOMATED BACKUP SETUP
Hello Everyone in this post we are going to cover how you can set automated backup functionality in a Microsoft SQL Server with Quick and Easy Steps. Create Stored Procedure Create Backup Job and Execute Delete/Modify Jobs 1. Stored Procedure backupDB CREATE procedure [dbo].[backupDB] as begin declare @path varchar(1000); set @path=’G:\backups\backup_’+CONVERT(CHAR(10), GETDATE(), 121)+’.bak’; BACKUP DATABASE […]
TYPES OF JOBS YOU CAN DO WHILE STUDYING
Generally, we have the mentality that we are not worth any job in a company while we are still undergraduate. But that’s untrue, rather we can apply and have a higher probability to get hired. Only thing is we should know where to apply. If we check the job openings number of vacancies for the […]