Viewing 15 posts - 166 through 180 (of 302 total)
Yes, that what it sounds like to me as well. When you restore the initial backup make sure you go to the Options tab (if you're using Enterprise Manager) and...
March 2, 2006 at 11:27 am
I'm not sure. You may need to install it and check the ODBC Administrator for a driver. Even if it uses OLE DB you may be able to use it...
March 1, 2006 at 5:39 am
Sorry but I don't know much about the DB2 databases. You may need to get with your DB2 expert or just do some testing. Our data pushes are very basic...
February 28, 2006 at 12:10 pm
Sure. We use an IBM DB2 ODBC driver version 7.01.00.28 and in the DTS package the data source connects using "Other(ODBC data sources)". We push data across several states every 20 minutes and...
February 28, 2006 at 10:54 am
Don't know if this will work or not, so I highly suggest that you try it on your own personal box or a test box first. Try changing the security...
February 28, 2006 at 9:33 am
Our databases haven't been upgraded to SQL 2005 yet, but we have linked servers to a DB2 and an AS400 in SQL 2000. We currently import data directly from them...
February 28, 2006 at 9:13 am
I don't know which method is best, but we use DTS and connect to a DB2 ODBC driver to push data and it works fine. I guess you'd need to...
February 28, 2006 at 9:04 am
I did the exact same scenarios using both applications and even tried 2 different versions of SQL Lite Speed. All of the Lite Speed restores were slower. I ended up...
February 6, 2006 at 2:36 pm
How are you trying to connect from the other pc's? ODBC, OLE DB, Query Analyzer, etc. Could it be that you have the SQL 2005 client installed on your pc...
February 3, 2006 at 10:54 am
You may also want to compare restore times. I've tested LiteSpeed and the backup speed was great and so was the compression, but the restore took longer than a native SQL...
February 3, 2006 at 10:42 am
You can download the SQL 2005 Enterprise Evaluation Edition to install & test with. Located here http://www.microsoft.com/downloads/details.aspx?familyid=6931fa7f-c094-49a2-a050-2d07993566ec&displaylang=en
February 2, 2006 at 6:54 am
Regarding the database backups... tell your supervisor that they are an absolute necessity. What are your plans for a disaster situation? Let's say you get hit by a natural disaster...
February 2, 2006 at 6:47 am
We have an active/passive cluster where the database is also log-shipped to a separate server for reporting. Works fine. Does that answer your question?
Linda
February 2, 2006 at 6:29 am
Now that's interesting. I got the same error connecting to a Virtual Server, but it resolved itself overnight. A mystery to me. (See my thread SQL 2005 on...
January 31, 2006 at 9:03 am
I can ping both ways successfully and can map to any shares. Interesting thing though, I can connect to SQL Server by name this morning. Just wondered if Active Directory...
January 31, 2006 at 5:51 am
Viewing 15 posts - 166 through 180 (of 302 total)