SQL-JP (7/8/2011)

---

We have a 750Gb DB we would like to shrink. There is unused space in the file, we have ran thew DBCC shrink file command with the truncate only...

Can you post me the results.

select create_date,name from sys.databases where name='abc'

JustStarted (7/6/2011)

---

Good article. I knew that Truncate is minimal logged operation but didn't knew that it logs deallocation of data pages.

I have one question though. I know Delete...

shanila_minnu (7/7/2011)

---

I am using SQL server 2000.i have one job which will extract data from one server after that it has to send mail to particular team.The problem is it...

anil_kumar32 (7/7/2011)

---

[font="Times New Roman"]

If recovery model for database is Full you should first take tail log backup before restoring. It will ensure that the modications that are not included...

sqluser_8119 (6/27/2011)

---

Once I do the full backup restore, do I have to apply each differential in order, or can I just apply the last differential from the 25th?

6/22/11 Full...

Mr J (7/3/2011)

---

Hi Jeffrey,

The server is SQL Server 2008 SP1 CU5, max memory is set at 4096Mb as for set lock pages can you explain further? Do you mean AWE?

Cheers...

JDBA-eqms (7/5/2011)

---

Hi,

I need to create a copy of that database on other Server.

I tried DBCC SHRINKFILE, but it doesn't shrink the file as there is no free space available in...

LutzM (7/5/2011)

---

May I kindly ask to stop the discussion at that point?

I don't see any new (question related) information added since several posts.

Let's just agree to disagree and move...

First why do want to reduce the MDF?

have you facing...

Thanks perry. Thats great info from paul.

Thanks to...

Incorrect syntax near '('. on Line 38

LINE38 > FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL , NULL) IPS

I noticed the compatibility mode of our db = 80 (SQL 2000)

Already changed DB_ID()...

Yes this will not do anything....

Coolroof (7/4/2011)

---

when i run the script i got this error...?

Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137

Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does...

Do you have any shrinking task?