SQL Server Backup & Restore

E’ facile fare un backup con sql server: Basta selezionare tasto destro Tasks>>Backup su un db. Ma come fare il restore?…
Ecco un semplice script che chiarisce la cosa (non sempre lampante dallo wizard di restore….):

-- Usare il seguente comando per recuperare i parametri sorgente da usare nella MOVE
-- Nel nostro caso ssaranno MY_BACKUP e MY_BACKUP_log
RESTORE FILELISTONLY 
 FROM DISK = N'C:\TEMP\MY_BACKUP\Backup.bak'  ;

--Ora usiamo questi parametri...
RESTORE DATABASE MY_BACKUP_Backup 
   FROM DISK = N'C:\TEMP\MY_BACKUP\Backup.bak'  
   WITH MOVE 'MY_BACKUP' TO 'C:\MY_DB_FILES\MY_BACKUP_Backup.mdf',
   MOVE 'MY_BACKUP_log' TO 'C:\MY_DB_FILES\MY_BACKUP_Backup.ldf', STATS = 10;
GO

Brasil4Win 1.1 and Jython 2.5a3: testing in progress

Because of the forthcoming release of Jython 2.5 (after an year of silence), we at Gioorgi.com are checking Brasil compatibility, right now.  What is Jython?… we read from the Jython website:

Jython is an implementation of the high-level, dynamic, object-oriented language Python written in 100% Pure Java, and seamlessly integrated with the Java platform. It thus allows you to run Python on any Java platform.

Jython 2.5 looks very promising, and we are planning Jython support for future Brasil releases.

Continue reading “Brasil4Win 1.1 and Jython 2.5a3: testing in progress”