hi,

did you have a look at the nt event log on _all_ nodes? This sounds as if the active node lost the disks! It's possible that during the network failures...

Hi,

is there enough free disk space?

What kind of file system do you use?

How many data files for your database?

karl

Hi,

you could try to replace the old domain name in the name-column of sysxlogins with the new domain.

(of course on a test server...)

Seems that is the only reference to...

Hi,

edited my prior post and added code of proc "user_trennen"...

Hi,

you can do the restore of all files in your container by using somthing similar to the following procedure:

/* **********************************************************************************

Procedure to restore TA-Logs into the Database

...

Hi,

i'm using a job that every night looks at the actual filesize and grows the database if less 1 GB is free...

(comments are in german, but you should easily get...

Hi,

how long does the copying run? i think the copy-job locks the log backup file...

perhaps you need to split the file containing the log-backups, so their size stays smaller.

karl

Hi,

do you copy the backup-files to another server? If yes, maybe that's not finished.

Are you creating a new file for every log-backup, or do you reuse the same file?

karl

Hi,

a lot depends on the overall strategy you have.

Will you do logshipping?

if yes, what is the size of the logfile(s)

What is your guaranteed recovery-time for the database?

Will one backup...

Hmm, as i remember the error about "not enough storage space" during installs may occur if there is no c:\temp, or if the path to the install-directory (if you install...

Hi,

don't you do backups of ALL your databases on a regular basis?

If you have got native backups of master, msdb and model (if you changed that one) all you have...

Do the errors occur at the publisher or at the subscriber?

Is the db at the subscriber set to autogrow too?

karl

Hi,

it's possible that your network admins restricted some tcp/ip ports for your VPN session. (possibly some netbios ports)

What connection-type are you trying? tcp, named pipes, multiprotcol?

Does "telnet yourServer 1433" get...

Yes, of course you can do that...

it is just something you have to think about:

if you do logshipping and the agent fails, you perhaps should failover, if it's just reporting...

Hi,

an other issue is SQLServerAgent...

If is crashes due to job-related problems, do you really want to automagically failover (and eventually disconnect your users?

Do you have other software which needs...