SQL Server 2000 backup command config

SQL Server 2000 backup command config

1.open [sql server enterprise manager]

2.open [microsof sql servers\sql group\local\manage\sql 代理程式\operation]

3.open and modify item

4.click [setup] and [edit]

5.modify [command] below

DECLARE @filename NVARCHAR(200)

set @filename = convert(NVARCHAR(19),getdate(),120)

set @filename = REPLACE(@filename,':','.')

set @filename = N'C:\backup\'+@filename+'_dbname.bak'

BACKUP DATABASE [dbname] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'dbname backup', NOSKIP , STATS = 10, NOFORMAT

VS config SQL Server

1.open vs

2.see on right frame the [server explorer]

3.mouse right click [data connections] and click [add connection] to open message box

..a.choose [Microsoft SQL Server (SqlClient)]

..b.keyin [server name] or IP

..c.choose [use sql server authentication] and keyin dbuser and dbpassword

..d.at [connect to a database], choose main dbname

..e.click [test connection] to test this connection or click [ok] to finish

Could not load type projectName.MvcApplication

if you modify sql connect string in web.config, and the page of asp.net config to happen below event, you must compile your project after open that page again.

-------------------------------------------------------------------

error messeng

-------------------------------------------------------------------

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Could not load type 'xxx.MvcApplication'.

SQL Server 2008 Develop Edition in W7X64PRO

1.run setup

2.click [new installation or add features to an existing installation] and [ok]

3.keyin [product key] and [next]

4.checkbox [i accept the license terms] and [next]

5.click [install]

6.problem scan [performance counter registry hive consistency] see http://support.microsoft.com/kb/300956

a.run regedit and goto [HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib\]

b.[009] use [export] to 009.reg

c.[0404] rename to [0404-1]

d.open 009.reg and modify [009] to [0404], double-click 009.reg after save and close

e.[re-run]

f.if you haven`t installed [sql server 2005 express tools] or remove before click [next]

7.[setup role] click [next]

8.[feature selection] click [select all] and [next]

9.[installation rules] click [next]

10.[instance configuration] select [default instance] or not and click [next]

11.[disk space requirements] click [next]

12.[server configuration] settting [account name(use system) / password] click [next]

13.[database engine configuration] select [mixed mode ...] and setting [password], [add current user] before click [next]

14.[analysis services configuration] click [add current user] before click [next]

15.[reporting services configuration] select [install the native mode default configuration] click [next]

16.[error reporting] click [next]

17.[installation configuration rules] click [next]

18.[ready to install] click [next]

19.[installation progress] click [close]

20.install service pack sp2 x64 and x86

Microsoft SQL SERVER 2005

　　（一）主程式安裝

　　　　１、在安裝於x64的作業系統上由於Report Serivces僅能運作於Win32的環境中，所以當IIS未能以Win32運作時，將會有錯誤訊息

　　　　２、安裝程式選項部份，點選「進階」來設定要安裝的項目及路徑(最好獨立實體硬碟)

　　　　３、執行個體名稱，若為第一部或本機第一個SQL SERVER請以預設名稱建立，或依個人需求更名

　　　　４、在「服務帳戶」的設置考量，若全為本機測試、開發，則以「使用內建系統帳戶」「本機帳戶」即可，若要用於遠端則必須調整為網域帳戶並將DataEngine開啟TCP/NAMES（通訊協定及具名）方式連結

　　　　５、修改驗證模式為「Windows驗證方式」，若要採用遠端則可改用「混合驗證方式」並設定SA（SQL SERVER的資料庫管理者）帳戶的密碼（密碼若有特殊字元將會在連結字串時誤判）

　　　　６、後續均以預設配置即可，至安裝結束

　　　　７、安裝修補程式及安全更新程式

　　　　　（１）安裝時請注意服務配合關閉，並於更新後開啟以便程式偵錯

　　　　　（２）由於SQL SERVER 2005在X64主機上仍以32位元模式運作，安裝完x64修補程式後，也要安裝x86修補程式

　　　　８、連結方式變更為TCP/IP與具名

　　　　９、安裝完主程式、變更組態或更新程式後，須重新開機

　　（二）開發設定：一般VS連接資料庫會採用安裝時一同安裝的SQLEXPRESS版本，若要改為SQLSERVER則要進行修改設定

　　　　１、首先開啟 SQL Server Management Studio ，登入後新建一個資料庫

　　　　２、接著開啟 資料庫安裝精靈 C:\WINDOWS\Microsoft.NET\Framework\v2.0.????\aspnet_regsql.exe 按步驟將會員相關資料表建立於所新建的資料庫中

　　　　３、開啟 vs的工具「連接資料庫」將連接字串記錄或複製下來，準備取代下面的(Data Source=localhost)字樣

　　　　４、修改 web.config

　　　　　（１）修改連接字串

　　　　　　　　找到

　　　　　　　　　<connectionStrings/>

　　　　　　　　複製代碼取代為

　　　　　　　　　<connectionStrings>

　 　<add name="SqlServices" connectionString="(Data Source=localhost)" providerName="System.Data.SqlClient"></add>

　　　　 　 </connectionStrings>

　　　　　（２）開啟vs的「專案」中的「ASP.NET組態」，點選「安全性」並啟動角色後，即可開始設定

　　　（三）安裝Microsoft SQL SERVER 2005 EXPRESS SP3，若要安裝MOSS則不安裝，若要安裝則以內建安裝後再升級至SP3