Question: Why is my mirror database in a restoring state? Hi, I am still working on DB mirroring with prinicpal and mirror. There will be no Witness. This is what I did and
2009-03-12
12,087 reads
Database Snapshots Can Take a Long Time to Create
Believe it, it's true!! One of the big selling point for database...
2009-03-11
4,832 reads
Question: Why is my mirror database in a restoring state?
This question was asked on a technical discussion group. This is...
2009-03-06
39,915 reads
Question: How do we handle transaction log maintenance for a mirrored database?
This question was asked on a technical discussion group....
2009-03-04
23,502 reads
How do I ... Determine Database Growth If I Am Not Tracking It? If your database has grown considerably and you're not sure when or why it happened, you'll be hard pressed to figure out the answer unless you're tracking changes in database size.
2009-02-27
4,388 reads
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online? This question was sent to me via email. My reply follows. Quick question on DB mirroring client redirection after Principal fails
2009-02-24
3,649 reads
Question: What would be the best practice to configure Failover Clustering and Database Mirroring?
This question is frequently asked in one...
2009-02-23
1,555 reads
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.
2009-02-23
1,567 reads
Question: Will the Mirror automatically fail back to the original Principal when it comes back online?
This question doesn't usually come...
2009-02-22
11,488 reads
How do I ... Determine Database Growth If I Am Not Tracking It?
If your database has grown considerably and you're not...
2009-02-20
5,967 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Tlp/Wa_Cs:0818-751-777. Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa...
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Are there any good articles on all the trace flags that are enabled on...
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers