Configure SQL Server Database Mirroring
1) Take Full backup of database at Principle Server
BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’
2) Take Log Backup at Principle Server
BACKUP...
2014-10-17 (first published: 2014-10-13)
15,953 reads
1) Take Full backup of database at Principle Server
BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’
2) Take Log Backup at Principle Server
BACKUP...
2014-10-17 (first published: 2014-10-13)
15,953 reads
Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database...
2014-10-06
10 reads
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
760 reads
Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download at the Microsoft Support site. SQL Server 2008 Service...
2014-10-02
17 reads
Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download...
2014-10-02
733 reads
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008...
2014-09-29
26 reads
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the...
2014-09-29
229 reads
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for...
2014-09-29
1,259 reads
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server...
2014-09-29
23,787 reads
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft...
2014-09-22
17 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers