SQL Script to Backup all SQL Server Databases Backup all databases on your server using T-SQL is a much simpler and faster. Below T-SQL script will generate backup of all databases with date stamp in backup file name. Update the backup path in below script. DECLARE @dbname NVARCHAR(256) DECLARE @filepath NVARCHAR(512) DECLARE @fileName NVARCHAR(512) DECLARE @Date NVARCHAR(40) -- Database backup directory SET @filepath = 'D:\backup\' -- filename format SELECT @Date = CONVERT(NVARCHAR(20),GETDATE(),110) DECLARE backup_cursor CURSOR READ_ONLY FOR SELECT name FROM master.sys.databases WHERE name NOT IN ('master','model','msdb','tempdb') -- exclude system databases AND state = 0 -- Online database AND is_in_standby = 0 -- database is not read only for log shipping OPEN backup_cursor FETCH NEXT FROM backup_cursor INTO @dbname WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @filepath + @dbname + '_' + @Date + '.bak' BACKUP DATABASE @dbname TO DISK = @fileName WITH INIT FETCH NEXT FROM backup_cursor INTO @dbname END CLOSE backup_cursor DEALLOCATE backup_cursor

configure vite.conf to allow cors requests

Fayyazuddin

I am trying to configure cors access to my project, since when making a request to an api it is blocked and gives me the following error in the console:

cross-origin request blocked the same origin policy disallows reading the remote resource at  https://geo.ipify.org/api/v2/... //my api key and the ip

I tried to set up a proxy server but it still won't let me. Here the configuration of the proxy server:

export default defineConfig({
  server: {
    proxy: {
      "/api": {
        target: "https://geo.ipify.org/api/v2",
        changeOrigin: true,
        secure: false,
        rewrite: (path) => path.replace(/^/api/, ""),
      },
    },
  },
  plugins: [react()]
})

Thanks.