sql server backup

/Tag: sql server backup

SQL Server üzerindeki tüm databaselerinizi yedekleyin.

By |2017-02-27T14:30:58+00:00Şubat 27th, 2017|Categories: SQL Servers|Tags: , , |

SQL Server üzerinde belkide 1000 tane databaseiniz mevcut, bunların herbiri için procedur yazmak yada job oluşturmak zaman alabilir. Vereceğim script ile yedekleme işlemini hızlı ve kolay bir şekilde kaç databasinizin olduğuna bakmaksızın yedekleyebilirsiniz. TechNet üzerinden bu scripte ulaşabilirsiniz.   [email protected](50)[email protected](256)[email protected](256)[email protected](20)--usedforf[email protected]path='MyBackupFilePath'[email protected]ate=CONVERT(VARCHAR(20),GETDATE(),112)DECLAREdb_cursorCURSORFOR--UsethisforalldatabaseexceptthesystemdatabasesandanyexclusionyoucanmakeSELECTnameFROMmaster.dbo.sysdatabasesWHEREnameNOTIN('master','model','msdb','tempdb','ReportServer','ReportServerTempDB') --Uncommentandusethisforonlyspecificdatabases. --ThosedatabasenamesyoucanprovideunderINclauseSELECTnameFROMmaster.dbo.sysdatabasesWHEREnameIN('MyDB1','MyDB2')[email protected]@@[email protected][email protected][email protected]+'_'[email protected]+'.BAK'[email protected][email protected][email protected]_cursorDEALLOCATEdb_cursor Kodu buradan indirebilirsiniz. http://gallery.technet.microsoft.com/T-SQL-to-backup-all-d683cfee/view/Reviews

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.