Hi Bhuvanesh,

I am not trying to reclaim the space. But I am just curious what will happen if the empty space is available in the data files. As such...

Gail I have a question. Why sqlsever default value is appending rather than...

Can you post us the exact error message and the select statement that was used?

It all depends on business needs. Normally 24/7 environment will have HA solutions as well as DR planned.

Fail over clustering gives you High availablity of your database. It does...

Part of the explanation can be found in this link.

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/25/exception-when-selecting-from-sysindexes-in-sql-server-2005.aspx

The above explanation does not suite to our data. But someone somewhere has got this issue. Still hoping...

Is this db is accessable. Why can't you just attach the snapshot of what you seeing the SSMS. 🙂

-- Babu.

Good Question !!!!!

I got a point. Good question.

Hi Koen Verbeeck,

Thanks for pointing out that.

--- Babu

Hi Michael,

The correct answer should be query 3 and 4. I did not see anything wrong with query 4.

I need my points back lol. 🙂

--- Babu

Your requirement is not clear. May be you should provide table structure with sample data and the output you needed.

It seems like you are expecting others to write your...

Good Question !!!.

nhphuong76 (1/29/2012)

---

I have statement and run it by SQL jobs

RESTORE LOG DB_SHOP FROM DISK = 'DB_backup_201201221250.trn' WITH FILE = 1, STANDBY = 'DB_backup_201201221250.bak', NOUNLOAD, STATS...

I found an article describing your symptons.

Can you try those options.

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/04ab5152-b99d-41f7-a181-417dcea84275

Please update the forum if that has worked for you.

Happy troubleshooting.

--- Babu

Go to the local services. Double click the mssql services. In the general tab will tell you where is the MSSQL program files are installed. Follow that and get the...