sorry, i forgot the option -m...

try

d:\..\MSSQL$LATIN_CP850_CIAS\Binn>sqlservr -slatin_cp850_cias -f -m

karl

if you start the server with option -f it should be accessible via EM, even if it complains about model or madb.

you can then change the paths in master.dbo.sysfiles and...

Hi,

after restoring master start SQL-Server with -f,

then restore msdb amd model with move (or set the correct paths in EM).

Next restart SQL Server, ignore errors about the user databases and...

Hi,

you can create a view that represents the data like you need it, and then write the table to html-file on disk via an Web-Task in SQl-Server agent.

Or you can...

Hi,

is the server perhaps set up for any kind of replication? If replication is configured but not working strange things can occur...

regards

karl

Or you create a view on server1 that points to server2 via an OPENROWSET..

karl

Hi,

also i would recommend not to use BACKUP LOG WITH TRUNCATE_ONLY but BACKUP LOG WITH TRUNCATE, because if the database backup fails for some reason, after doing ..WITH TRUNCATE_ONLY you...

But don't forget that changing the servers collation does _not_ change the collation of any already existing database, table or column!

regards karl

Hi,

you also could create views on the sql server that use OPENQUERY statements. That way thee end user needs only rights for the view, and you could use an appropriate...

Hi,

seems to me there are some misunderstandings under way:

first:

_never_ use BACKUP WITH TRUNCATE_ONLY on a system you want to be able to restore. That one is only for certain...

Hi,

just curious, are you performing custom logshipping, or is it the out-of-the-box procedure?

Are you restoring the failing database from a network share or SAN, or from a local disk?

Can...

Hi,

this works for me:

use master

declare @DBN sysname

set @DBN = 'test'

exec master..kill_users @DBN --sproc to kill all users using the db...

RESTORE DATABASE @DBN...

Restoring over the network won't diminish the amount of data to send over the net.

If you've got a slow network think about zipping the backup before copying (via gzip)...

regards karl

usually each node has it's own IP-address, and the virtual server has a different IP, which is only active on the active node.

other methode: if it's an active/passive SQL-Cluster you...

1.) exactly

a.) If you configure a static IP directly on the server, you have to exclude this IP on the router. (If you configure the MAC as static IP you...