Viewing 6 posts - 1 through 6 (of 6 total)
We also us DataMirror TS. Very similar set-up to Mike's. AS400 OLTP to Sql Datawarehouse.
We do a lot of date transformations (char or num to datetime). The product works well for...
March 9, 2005 at 6:22 am
#546122
Last month, I migrated a test server to a new machine following a very similar path as the one you describe. Last weekend, I migrated all of our production databases (42)...
February 3, 2005 at 9:13 am
#540421
quote: Thank you everyone. I cannot get into isql.exe because apparently I do nto have the correct password. I am going to actually try backing...
quote:
I cannot get into isql.exe because apparently I do nto have the correct password.
I am going to actually try backing...
December 5, 2003 at 5:12 am
#484771
Tempdb can't be backed up. If you want to move it, you'll need to run an ALTER DATABASE statement, with a MODIFY FILE clause.
December 5, 2003 at 4:59 am
#484770
Have you tried using isql.exe from a command prompt? If this tool is available you could run the procedures from there.
You don't need to copy the sp_helpdb procedure.
December 4, 2003 at 6:54 am
#484588
Some of this may be depend upon how many people can make changes to your servers!! But these are some items I monitor as well...
SQL configuration settings
SQL file versions (Service...
November 25, 2003 at 4:50 am
#483512