restore database with backup and transection logs

USE master
GO
-- First determine the number and names of the files in the backup.
RESTORE FILELISTONLY
FROM disk = 'C:\yourfolder\yourdbbackupfile.BAK'
RESTORE DATABASE yourdatabasename
FROM disk = 'C:\yourfolder\yourdbbackupfile.BAK'
WITH NORECOVERY,
-- change location
MOVE 'xxx_Data' TO 'C:\newfolder\newfile.MDF',
MOVE 'xxx_Log' TO 'C:\newfolder\newfile.LDF'
GO

RESTORE LOG yourdatabasename
FROM disk = 'C:\yourfolder\logfile1.TRN'
FROM disk = 'C:\yourfolder\logfile2.TRN'
WITH NORECOVERY
GO

-- WITH NORECOVERY need attach database, or WITH RECOVERY then dont need attach.

Comments

Web synchronization option for merge replication

http://msdn2.microsoft.com/en-us/library/ms151319.aspx SQL Server 2005 Books Online Implementing Replication over the Internet Replicating data over the Internet allows remote, disconnected users to access data when they need it using a connection to the Internet. Replicate data over the Internet using: A Virtual Private Network (VPN). For more information, see Publishing Data over the Internet Using VPN . The Web synchronization option for merge replication. For more information, see Web Synchronization for Merge Replication . All types of Microsoft SQL Server replication can replicate data over a VPN, but you should consider Web synchronization if you are using merge replication.

html5 file upload

Note: slice method from File API was replaced by mozSlice in Firefox and webkitSlice in Google Chrome

Request Signatures in Blackberry

Request Signatures in Blackberry need copy sigtool.db, sigtool.csk to SDK/component/Bin folder for example V 4.2.1 ../eclipse\plugins\net.rim.eide.componentpack4.2.1_4.2.1.17\components\bin

Field Mapping

Search This Blog