By using cliconfg on the clients you can select which protocol is used. If the client needs to connect to different servers you can create aliases for each server, each...

you could use "SET DATEFORMAT dmy" at the beginning of the sproc...

coincidences, coincidences...

Last night i was called to work, the sql-database behind our company's VERITAS Backup Exec was defect, with no backup having ever been made (obviously not a server/db i...

How about creating a view on the dest server with OPENROWSET to source server, and then inserting the data via select * from view?

karl

Hi,

yours seems to be another case of Collation Hell.

Changing the collation of a database does not change existing columns, it changes only the system tables, and sets the default for...

SELECT RTRIM(CONVERT(varchar,SERVERPROPERTY('productversion')))as Productversion,

RTRIM(CONVERT(varchar,SERVERPROPERTY ('productlevel')))as Productlevel,

RTRIM(CONVERT(varchar,SERVERPROPERTY ('edition'))) as Edition

EXEC master.dbo.xp_msver

One method to get the rest of the logfiles into the server would be to use a third-party tool (Apex SQL Log claims to be able to do that) to...

2) Yes, it's also a test for your backup/recovery procedure.

Each backup you have been able to restore into standby has shown that it is ok in case of an disaster...

One more point: i'm assuming daily db-restores because for me the standby-server gives availability, but at least as important as that is: it's living proof that my backups and restores...

I'm also assuming that he first restores the database and only afterwards starts the job doing the log transfers. That way the first conflict would occur the day after..

Perhaps i'm...

Hi writes:

Truncate log

Full backup database, INIT(daily)

Copy database

Restore database, STANDBY,REPLACE

I assumed that he restores the db daily also. If so, the truncate before db-backup and -restore won't affect the outcome...

Hi,

neither the truncate log nor the with_notruncate should have an impact on your logshipping.

Most likely the restore of the full backup is not finished when the first log-restore starts. Therefore...

Hi,

check the connection settings, do you connect with the same user in QA and osql?

karl

Hi,

how is the job started? If you start it from a linked server, you might be running into the connection-timeout...

karl

If you don't use "backup log with truncate_only" then your plans will work.

If the TL gets to 4 GB twice a week, i would simply not mind...

As long as the...