Hmm, did you find NETLOGON errors in system log? We've had trouble like that when our servers somehow lost connection to the domain servers...

Did you look at the eventlog - security. If security is logged, you should see the attempted logins...

karl

Hi,

you should never use mapped drives for logshipping, because the drive mapping lives in the user profile.

use UNC or ip address for the shipping:

\\servername\share

or

\\172.16.1.1\share

A basic introduction how to manually set...

Hi,

you might even use a active/active configuration, with 2 instances of the sql server on different ip adresses, 2 cluster groups, 2 Disk groups. normally each instance would run on...

select operation,[checkpoint end],[Begin time],[end time] from ::fn_dblog(null,null)

gives you the start and end times of every transaction that is in the active part of the ta-log

Also a lot depends on your guaranteed recovery time. The shorter the time you get to recover after a disaster, the more often you will need to do a differential-...

Hi,

you might try fn_dblog, but it won't give you SQL-Statements...

fn_dblog returns a table of records from the transaction log.

The syntax of the call is:

select * from ::fn_dblog(@StartingLSN,...

I was told, that normally on a server with 4 GB RAM Windows uses the upper 2 GB, and userspace is in the lower 2 GB. If you add more...

Hi,

has the nt-user a valid login-id and user id for his standard database?

Is the sql server configured for integrated security?

Does the client use the same network library (tcp/ip, named...

What kind of operating system is running on the file server?

If Windows 2000 or 2003, are you using named pipes?

If yes, perhaps you need to see Microsoft Knowledge Base Article...

Hi,

i would recommend

http://www.sqlservercentral.com/columnists/mpearson/changingroguedatabasecollations_printversion.asp

if your tables have a lot of columns you might run into trouble with the script for copying data. In that case i...

Hmm, to clarify, is the SqlAgent service "started" or "starting"?

While "starting" you can't stop it, and usually it won't start any job.

I've hat that problem on some servers, if the...

Hi,

you might simply create the missing table and leave it empty...

(if its joined with an outer join)

karl

Hi,

if you configured sqlagent with an outlook email profile, check if the profile is valid. If it's valid, set sqlagent to start manually, reboot, log in as the service user,...

Any messages in system- or security log around that time?

Did somebody delete or deactivate the service account?