Create SQL Script to Backup/Restore databases

Rédigé par M Sozezzo - - Aucun commentaire

Create SQL Script to create SQL Script to backup databases and to restore databases.

- Fix owner user : 'sa'

- Shrink databases

 

Tip: You can use a shared folder;

Tip: You can disconnect all users before to restore a database;

Tip: You can add this SQL Script to protect executing on the wrong SQL Server;


IF (NOT(@@servername = 'MyServerName'))
BEGIN
   PRINT 'You MUST execute over MyServerName';
   RETURN;
END

 

Lire la suite de Create SQL Script to Backup/Restore databases

Fil RSS des articles de ce mot clé
PHP Warning: include_once(plugins/simplepie/simplepie.inc): failed to open stream: No such file or directory in C:\Inetpub\vhosts\sozezzo.com\httpsdocs\blog\plugins\simplepie\plx.simplepie.php on line 2 PHP Warning: include_once(): Failed opening 'plugins/simplepie/simplepie.inc' for inclusion (include_path='.;.\includes;.\pear') in C:\Inetpub\vhosts\sozezzo.com\httpsdocs\blog\plugins\simplepie\plx.simplepie.php on line 2