Backup database in CMS
Sometime you know the database name which you want to backup, but you don't know which server it is on....
2012-05-09
1,096 reads
Sometime you know the database name which you want to backup, but you don't know which server it is on....
2012-05-09
1,096 reads
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
6,821 reads
SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...
2012-04-25 (first published: 2012-04-21)
12,324 reads
When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...
2012-04-19
1,004 reads
Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping....
2012-04-18
2,452 reads
Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...
2012-04-10
6,388 reads
Today I need to shrink a big data file, I know shrink file is not a best practise, and it...
2012-04-07
2,094 reads
I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet...
2012-04-06
26,159 reads
Not sure if it is a good news or bad news, SQL Server 2012 license shifts from processor-based to core-based.......here...
2012-04-05
1,922 reads
After installing the SQL Server 2012 on my laptop, I found there is only online document available, no local book...
2012-04-01
25,952 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers