Hi,

this was the first hit with google:

move ERRORLOG:

https://blogs.msdn.microsoft.com/varund/2009/08/27/steps-to-change-the-default-location-of-sql-server-sql-server-agent-error-log-files/

move system database:

https://technet.microsoft.com/en-us/library/ms345408%28v=sql.110%29.aspx

Or do you search something special?

Kind regards,

Andreas

Hi,

I think you need a monitoring tool, or you had to lock at the performance counters from performance monitor.

Just collect them for 1 week, and you find your window...

Hi,

the user which will performe this action, is this a SA user, or has this user the required rights:

"ALTER ANY LOGIN"

Kind regards,

Andreas

Hi,

on which server did you get this error, publisher, subscriber or distributor?

What about the size of you "lob" data?

Kind regards,

Andreas

Hi,

I think, without the error message, we are not able to help.

Please post the error log, or the error message.

duplicated post:

http://www.sqlservercentral.com/Forums/Topic1793594-3412-1.aspx

:w00t:

Hi,

I don't know the source of your query, but if you got bytes, you had to divide 3 time

Bytes / 1024 = KB

KB / 1014 = MB

MB / 1024 =...

Hi,

in this link is explained, which data is stored in the tempDB:

https://msdn.microsoft.com/en-us/library/ms190768.aspx

Internal objects that are created by the SQL Server Database Engine, for example, work tables to store intermediate results...

Hi,

I think this is impossible, SQL is a database tool, no video tool. I've never heard, that sql cmd could manage such a task.

Kind regards,

Andreas

Hi,

you can use this query to look into your database, how much storage is really needed:

USE yourDatabase

GO

sp_spaceused

The value "unallocated space" is the free space in the database, and is not...

Hi,

are all services from the sql server starting with local accounts?

Are you able to start the sql server services with a domain account?

If you are working with DR or...

Hi,

have you checked with your domain admins, if there is a valid SPN in the domain for you SQL-Server?

Kind regards,

Andreas

reported as SPAM, but it sucks!!!

reported as SPAM

reported as SPAM