It lookc that client uses Named Pipes instead of TCP/IP. Make sure that TCP/IP is enabled in client tool (cliconfg) and TCP/IP is the first protocol.

You can actually improve Transaction Log's performance by shrinking it and resizing it properly (when database has many VLFs). Kimberly Tripp has great blog about Log's performance: http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx...

The problem with wide columns is that even though SQL Server supports now larger row size the maximum capacity specification is still 8,060 bytes per row. If the row becomes...

Yes, I tested it on environment without Kerberos. Thanks for correction.

You can have Windows logins on source database , but they have to be mapped to SQl Server logins on remote server. Windows to Windows logins mapping does not work.

Hi,

The minimum role required is db_owner. The DTA checks is the user is member of db_owner role before it creates session.

Hi,

Be careful with revoking permissions from public role. It captures all default permissions for users in a database and you may have issues if you remove all permissions. Permissions should...

Hi,

Never make modifications on SharePoint tables unless you are completely confident and understand what you do. Better never do this at all.

I think that your problem is related to the...

You can generate script using this query:

use master

go

SELECT 'EXEC [' + name + '].dbo.sp_grantdbaccess ''login'', ''userNameInDB''' from sysdatabases

SELECT 'EXEC [' + name + '].dbo.sp_addrolemember ''db_owner'', ''SuperUserLogin''' from sysdatabases

Run the output...

Not sure if this is the best solution, but this is what I do when I have similar tasks:

1) add another datafile to the filegroup

2) shrink the first file with...

Get familiar with applications using databases. I usually get applications names, vendors contacts, application support contacts, business owners and SLAs (if exist) first week. Also try to find which database...

Good question! Reminded me that NULL and empty string are not the same thing.

I don't see any errors in this error log. You may try my suggestion again (to create new virtual directory) and check error logs right after that.

Hi,

To restore the database that have been backed up to the multiple files you just need to list all devices:

RESTORE DATABASE database_name FROM backup_device1, backup_device2...

Do you get any errors in event log or in Reporting Services logs (Drive:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles)?