I might be missing something so I'm hoping someone can clear it up.

I have used TRUNCATEONLY on log files in SQL 2008R2 before to remove VLF fragmentation. I double checked...

Is the database set to auto close?

This should do it

CREATE TABLE #srvroles(ServerRole VARCHAR(20), Membername VARCHAR(200), MEMBERSID VARBINARY(MAX))

GO

INSERT #srvroles EXEC sp_helpsrvrolemember

SELECT 'EXEC master..sp_addsrvrolemember @loginame = N'+''''+MemberName+''''+','+'@rolename = N'+''''+ServerRole+''''

FROM #srvroles

GO

DROP TABLE #srvroles

You need to register your Central Management Server with SSMS on the machine you want to query from.

In SSMS:

Go to View>Registered Servers

Right click on Central Management Servers>Register Central Management Server

Enter...

Lynn Pettis (8/9/2012)

---

SQLJocky (8/9/2012)

---

I'm trying to figure out why this log file won't shrink down past a certain size. I'm doing it on a brand new database I'm creating...

I would take a backup of all the databases prior to the move in case something was to happen to the luns during the move.

I would also run select name,...

Try this:

EXEC sp_MsForEachDb @command1 =

'DECLARE @COPYDatabaseUserName [sysname]

SET @COPYDatabaseUserName = ''Domain\Laurine Torrone''

SELECT

S.[name],

S.[principal_id],

R.[role_principal_id],

''ROLE'' AS [role_name],

S.[default_database_name],

S.[default_language_name]

FROM ?.sys.server_principals S

INNER JOIN ?.sys.server_role_members R

ON R.[member_principal_id] =s.[principal_id]

WHERE S.[name] =@COPYDatabaseUserName'

I'm not sure if you are using an unconventional extension on the log file but SQL database log files use .ldf not .log. It looks like you have an extra...

This will tell you if Database Mail is enabled. It might not be configured however.

sp_configure 'show advanced options', 1

reconfigure

GO

sp_configure 'Database Mail XPs'

Did you read anything from the link?

The 3rd bullet point in:

Subscriber version depends on the type of publication:

A Subscriber to a transactional publication can be any version within two versions...

Just a guess, but are you using native SQL backups? Or is some 3rd party software running the backups?

Some 3rd party software will detect if a backup outside of it...

Log shipping from SQL 2008 to SQL 2005 will not work.

However, replication from SQL 2008 to SQL 2005 will work. Check out the article below for the caveats.

http://msdn.microsoft.com/en-us/library/ms143241.aspx

Yes, this is possible.

http://msdn.microsoft.com/en-us/library/ms143699.aspx

The release services blog is great for...

The following will change the initial size to 10,000MB. You will need to restart the SQL Server service for it to take effect.

ALTER DATABASE tempdb

MODIFY FILE

(NAME = tempdev, SIZE...