kumarramachandrarao (6/27/2011)

---

hi

can any one tell me how to check the version in which version the backup was taken from sql (2005 or 2008 or 2008 r2 or 2008 r2...

See the status if its shows 0 the log file not in use if its 2 its in use.

The log file is just a circular it will reuse the inactive...

SC.SQL.Dev (6/24/2011)

---

Hi all

DBCC SHOWFILESTATS

can be used to show the unallocated space of mdf and ndf (data) files for a specific database.

Is there a way that the same information can be...

George your welcome. I didn't post any link.

No problem see the link here

Don't shrink the database instead of shrink the...

beejug1983 (6/24/2011)

---

I took tail log backup with no_trucate syntax as Gail suggested. I was able to take Tail Log backup and point in time recovery successfully done. Thanks all for...

Alter the database and point the file to another drive (or) Add new drive.

matt6749 (6/23/2011)

---

I just added 750,000 Canadian zip code records to my existing U.S. zip code table.

Query execution time for a U.S. zip code search: ~150 milliseconds

Query execution time for...

John Mitchell-245523 (6/23/2011)

---

Is your database in Full recovery mode or Simple? If Full, how often do you back up your transaction log? How much of the 135GB is...

tt-615680 (6/23/2011)

---

muthukkumaran Kaliyamoorthy (6/23/2011)

---

tt-615680 (6/23/2011)

---

Hi All,

I have an SQL 2000 Database which is 135GB and I want to perform "Shrink Database" but I want to know what is the maximum...

tt-615680 (6/23/2011)

---

Hi All,

I have an SQL 2000 Database which is 135GB and I want to perform "Shrink Database" but I want to know what is the maximum percentage that I...

narwhal (6/23/2011)

---

Hi,

I came across this error " The file *.mdf is missing and needs to restore" .can anyone provide me proper solution to come out of this situation? Thanks in...

standard or enterprise

gaurav.kothari 39274

Take a test/Dev server use the upgrade advisor and test it your app fully.

kesmond (6/21/2011)

---

Hi, i have a queries, i have do a testing (sample) to set the transaction logs backup to occur every 5 minutes. But i have check that how come...

I am rather new to sql so in terms of backup, would need your advice.

So i would do a restore from the full backup for Monday (with the restore option...