Originally Posted by hdawg
When you setup the 2nd database server did you simply just copy the database over or did you use the createdb.exe command to create a database shell and then copy the database over?
The latter would be the proper procedure.
Yes I am using the following
sqlcmd -S "ServerName" -U sa -P password -i "path to a sql file" containing
BACKUP DATABASE BESMGMT TO DISK and a path to where I want the .bak created. I then have that file copied to the other server (Normal Copy Process) and run a the above command with its sql file containing RESTORE DATABASE BESMGMT FROM DISK. <-THis is done daily at 6am.