anthony.green (1/28/2013)

---

Prices will vary depending on your agreement with MS and what plan you are on, eg Select aggreement, EA aggreement, Open Value, EAP etc etc.

Base price on NL without...

Hi, I'm running the same problem in a SQL Server 2008 Box.

I believe that is a performance / index fragmentation issue, because this database is around 11 TB....

Stop the running server.

2. Open a Command Prompt and go to the SQL Server directory.

3. Type:

sqlservr -m -T4022 -T3659 -q"new collation"

Example: sqlservr -m -T4022 -T3659 -q"latin1_general_ci_ai"

I don't know How,...

It worked, but I got the message:

Msg 6841, Level 16, State 1, Line 7

FOR XML could not serialize the data for node 'processing-instruction(definition)' because it contains a character (0x0000) which...

This script saved my head: tks a lot

start /wait <DVD Drive>\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword> SQLCOLLATION=<NewSystemCollation>

I Have this issue running SQL Server 2008 and this message was in the log:

"Login failed for user '%'. Reason: Token-based server access validation failed with an infrastructure error....

I Have this issue running SQL Server 2008 and this message was in the log:

"Login failed for user 'CENTRAL\operacao'. Reason: Token-based server access validation failed with an infrastructure error....

I had this trouble about 1 mounth ago and fixed exactly as you said...

I spent more than 13 hours to figure out what was happening...

I'm sure that you...

Hi,

1)The fill factor is already set to 90.

2)The growth predicted has reached months ago…

I´m think that there are something related to duplicated data, however SAP has about 50K...

Hi Jones, transaction log backups are done every 5 minutes, sometimes they have 1,5GB, usually they have 300MB. The log files are limited to 50 GB and believe this...

I did the first SYSALTFILES select posted after a...

Hi Nilmov...

Sorry to take so long to anwser...

It worked perfctly!!!

Thank...

Please run this command and post the result, I think I have the same problem here...

select * from sysfiles

select * from sys.sysaltfiles where [dbid] = 'your db id'

Regards

Edu

Adam, good job! really good view!!!

Make sense, but no body can connect to this database, and this occur when...