sp_configure 'min server memory (MB)', xxxxx

go

sp_configure 'max server memory (MB)', xxxxx

go

reconfigure

go

For clickability

http://blogs.technet.com/b/patrick_heyde/archive/2010/05/27/advanced-maintenance-for-sharepoint-databases-defrag-update-index.aspx

http://blogs.technet.com/b/patrick_heyde/archive/2009/03/31/how-to-defragment-sharepoint-databases.aspx

A full backup doesn't backup the transaction log, you need to take regular transaction log backups to make the log re-usable and stop it from growing out of control.

Managing Transaction...

I have provided 4 links above which will guide you through the process.

There is also the SQL Server Backup and Restore book by Shawn McGehee in the "Books"...

BOL will take you through the syntax needed to do backups and restores

BACKUP (Transact-SQL)

RESTORE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms179451%28v=sql.105%29.aspx

http://msdn.microsoft.com/en-us/library/ms190982%28v=sql.105%29.aspx - I would recommend once ready to run it via the GUI to actually...

Yes there is typically a huge difference depending on what you want to do.

Cursors are typical RBAR meaning it processes a row at a time, where as with a table...

I would create the subscription as you would normally via SSRS front end, then I would remove the schedule from the job it creates to run that subscription. Then...

sanket kokane (11/8/2012)

---

McSQL (11/8/2012)

---

Ah apologies, yes you're right, you would have to set RECOVERY to SIMPLE and then run the shrink commands in SQL 2008.

Forgot that this was a discountinued...

TRUNCATE_ONLY has been removed in SQL 2008

Probably as I stated on my post above, the active portion of the log was at the end and it needed the second backup to move the active portion back...

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/

Why is my transaction log full - http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Stairway to Transaction Log Management - http://www.sqlservercentral.com/stairway/73776/

Some good links above on transaction log management.

As you have run shrinkdatabase I...

The first thing that stands out is why do you have all the NOLOCK hints? You are aware of the problems that this hint causes?

Second you need to treat...

Create a package and then a connection manager which connects to your SQL Express instance, then drag in a Execute SQL task, give it the connection manager name and the...

Please post the full query.

Depends on your application, if it runs in 32bit mode, then 32 bit, if it runs 64bit then 64bit.