Chaos, complexity, curiosity and database systems. A place where research meets industry
Welcome
Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
Monday 4 May 2009
Create a script to backup user databases
This creates a script that will backup all user databases on the server.
USE MASTER SELECT 'USE [' + NAME + ']'+ 'BACKUP DATABASE [' + NAME + ']' + 'TO DISK = ''Z:\oneoffbackups\' + NAME + '.bak'' WITH INIT' FROM sysdatabases WHERE dbid > 4
No comments:
Post a Comment
Note: only a member of this blog may post a comment.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.