to effectively shrink the log file you will need to back it up first

then the error wasnt network related or instance specific was...

varshachyk (4/24/2010)

---

Hi All,

on one of our server Re-build index job is failing with the below error. Please suggest.

Failed: (-1073548784) Executing the query "ALTER INDEX [PPS_USER_SESSION_COOKIE] ON [dbo].[abc] REBUILD WITH (...

if the database is in full recovery model then log backups are...

the following will work for sql2005 on

select...

Can you supply a little more info on the error. Check the SQL server and Windows event logs

Paul

Good link. As Slava points out though the memory release process can be very slow especially under pressure. For that reason I, like others, err on the side of caution...

What does the following query produce on each server? Can you post the results?

select serverproperty('Collation')

2 words, Regional Settings!!

The default collation out of the box is dynamic 😉

The collation is defined by the regional settings on the server, you can change but if you accept...

is there a firewall in between the IIS server and the SQL Server?

Can you ping the SQL Server from the IIS box?

Can you telnet successfully to the SQL Server instance...

if you're wise you will setup a test system first and test this thoroughly. The jump from SQL7 to 2005 is huge and the database compatability level will possibly not...

i have experienced backing up SQL Server databases using DPM and i gotta say i'm not a great fan of the product at all. I use Redgate SQLBackup to backup...

you want to ensure the OS has at least 4GB to manage the process memory efficiently

Guys

just checked my SQL Server 2008 Ent x64 instance and guess what?? Yep, you got it, it's the same as yours

open the database diagram and right click then select copy to clipboard. Once on the clipboard open your favourite image editor Paint.net and paste into a new image