Viewing 13 posts - 46 through 58 (of 58 total)
Using EM, in the restore dialog box, under the Options tab, check to make sure the mdf and ldf file locations/names match what's on the new server.
Experience: the comb life...
February 28, 2003 at 10:06 am
Encountered same problem following sp3 install. Right click My Computer, Manage, Services and Applications, Services. You will see SQL Server Agent in 'Starting' mode. I had to...
February 10, 2003 at 2:57 pm
Great writing, easy to understand even for a novice like me!
February 3, 2003 at 1:38 pm
Thanks to Patrick Gallucci via the mssqldba@lazydba.com listserv! Here's the fix:
This is because there is no DBO assigned to the db that is recognized on
the server.. Create a...
January 22, 2003 at 7:21 am
Just threw them all out and started over again. Built new LS plan, will see if it works now.
January 21, 2003 at 11:55 am
I'm trying to establish log shipping between networked servers running Server 2000 (NT 5.0). Need warm-standby, read-only access on secondary server for reporting. Got LS to work with norecovery...
January 21, 2003 at 11:02 am
14) Multiple Instances on one server
(Max of 16 instances. 32,767 databases in each)-- Great for Enterprise Server
15) Log Shipping
January 16, 2003 at 3:04 pm
And the winner is Scorpion_66!! That's exactly what I'm looking for! You get the hero award from our applications staff! Send to gary.fahrlander@zurichna.com
Thanks,
Gary
A good day of...
January 14, 2003 at 7:45 am
I use a domain account for my installations (32-SQL2K/10-SQL7/1-SQL6.5). Had to have Network Security create a account with password that never expires and add it to a domain group...
January 13, 2003 at 8:29 am
Thanks Ross! That's it exactly and any other differences you may have encountered like dates, etc. to be able to ftp and dts the files into MSSQL.
January 9, 2003 at 10:29 am
Mainframe will not be UPDATING to SQL server directly. We are writing data extract programs to create files to ftp down to server and will import via DTS package...
January 8, 2003 at 12:15 pm
Thanks John, but what I'm really looking for is a cross reference table like this:
SQL Server DB2 COBOL
Integer ...
January 7, 2003 at 12:32 pm
For example:
DB2 defines Integer as
-2,147,483,648 to +2,147,483,647.
In COBOL this translates to
PIC S9(9) USAGE COMP.
January 7, 2003 at 11:45 am
Viewing 13 posts - 46 through 58 (of 58 total)