Yes, you are correct. And also SQL 2008 came with new feature called Compress the file.

Restore the previous Full Backup and you will be on track.

Why you want to read the Tlog?

I agree with Cath Trimble, You can take tlog backup to free up the log file space. Check on time to Temp DB and cleanup unnecessary data from the DB....

Use this script to selecr the defragmentation and it will generate the DBCC script as well, so you need to copy that script and run on the Databse.

-- Declare variables

SET...

What is the size allocated to the DB and how much data in the DB? Daily Shrinking DB is not a Best Practice. Why can not you add more disk...

I Fully agree with Mani.

satish.edms (6/24/2008)

---

Hi Manoj,

I have migrated the data from Access to Sql Server 2005. The Issue is i was given with 2 Access databse files ie.., db1.mdb(Present in client base location1)...

Why you want Stored Proc, You can do it from DTS or SSIS package. No need to write a SP or any other things.

Why can't you observe it before attaching it. Must remember you should not attach or restore from higher version to lower version like from 2005 to 2000 or from 2000...

Rana, This we already discussed in some other thread. Could you please try to add new log file on the server, if not go with the latest backup copy of...

Is it possible for you take backup of Access DB and restore it into SQL 2005 server? This is the way that you can restore it into SQL2005.

Let us know,...

Virtual server name is the name of the server who is the mediator netween your nodes. Suppose virtual server name is SSV100...

peer_mohamed2k (6/19/2008)

---

Hi,

I have A.dat file. Using BCP How to restore file to a new database.

I am trying in this way.

BCP ASPT in -iA.dat -t

Here ASPT is new databse name. It...

chalexander (6/23/2008)

---

So can I setup backup/maintenance jobs on both servers that are identical? Will I be able to connect to the SAN drive on both servers in the cluster even...