Tag » SQL « @ 肖恩D++

One Script to Backup All SQL Databases

Posted on August 15th, 2011 Sean Add comments

It’s a nightmare for backup your DB if you have 100+ DB’s in SQL server. Just simply run a script while you taking a coffee:

DECLARE @name VARCHAR(50) -- database name  
DECLARE @path VARCHAR(256) -- path for backup files  
DECLARE @fileName VARCHAR(256) -- filename for backup  
DECLARE @fileDate VARCHAR(20) -- used for file name 

SET @path = "C:\Backup"

SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)

DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb') 
--skip system database (optional)

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0
BEGIN
       SET @fileName = @path + @name + '_' + @fileDate + '.BAK'
       BACKUP DATABASE @name TO DISK = @fileName

       FETCH NEXT FROM db_cursor INTO @name
END

CLOSE db_cursor
DEALLOCATE db_cursor

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup

DECLARE @fileDate VARCHAR(20) -- used for file name

SET @path = "C:\Backup"

SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)

DECLARE db_cursor CURSOR FOR

SELECT name

FROM master.dbo.sysdatabases

WHERE name NOT IN ('master','model','msdb','tempdb')

--skip system database (optional)

OPEN db_cursor

FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0

BEGIN

SET @fileName = @path + @name + '_' + @fileDate + '.BAK'

BACKUP DATABASE @name TO DISK = @fileName

FETCH NEXT FROM db_cursor INTO @name

END

CLOSE db_cursor

DEALLOCATE db_cursor

ASP.NET Database, SQL

(No Ratings Yet)

Visual Studio Website Administration Tool & SQL Server Express

Posted on June 24th, 2010 Sean 1 comment

In Visual Studio the Website Administration Tool lets you view and manage the Web site configuration through a simple Web interface. But sometimes there is problem which is when using the Website Administration Tool to make a new connection for a new website, for example, using the security tab of the Website Administration Tool to manage rules for securing specific resources in the web application or website, it will display an error message “Unable to connect to SQL Server database”, even you have SQL Server Express installed and no problem to connect to it.
To solve this problem, try one or more of the following ways:
Read the rest of this entry »

ASP.NET Database, SQL, Visual Studio