Viewing 15 posts - 39,181 through 39,195 (of 39,456 total)
If you set this to true, then every minute or so, a checkpoint occurs. The transaction log is then truncated.
Example:
0800 DB full backup
0805 write transaction 1
0806 Check point, log cleared...
October 22, 2001 at 10:42 am
Also, what is the IO structure and the Index structure. You many have too many indexes. If you rebuild the clustered index, then you will be moving all the data...
October 22, 2001 at 10:41 am
You can have multiple data transform tasks between the connections. You need a separate "query" for each to get different data.
Steve Jones
October 22, 2001 at 10:37 am
Does it work from the local server? If it does, then this doesn't make sense.
Steve Jones
October 22, 2001 at 10:35 am
Yes. With v7., the query engine was substantially enhanced. Some more improvement in 2000. At this point, you should run 2000. You can set a db to run as...
October 22, 2001 at 10:34 am
October 22, 2001 at 10:31 am
October 22, 2001 at 10:31 am
There is a script here that will do this.
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=90
Also another:
Steve Jones
October 22, 2001 at 10:04 am
you can setup telnet (security risk). There is also a remote command server (like telnet). See the resource kit.
Don't know of any SSH, but there probably are some.
Steve Jones
October 20, 2001 at 1:17 pm
Do you have this installed on the remote machine?
It is installed as part of the SQL Server client tools.
Steve Jones
October 19, 2001 at 1:35 pm
That's an interesting idea. If these are not VLDBs, then that might work. I assume that if you log ship from one db to another, that the recipient db can...
October 19, 2001 at 9:48 am
October 19, 2001 at 8:13 am
You probably need a JDBC-ODBC bridge or maybe some of the Java vendors have native ones. Never seen one that was free, however.
Steve Jones
October 19, 2001 at 8:11 am
Interesting. I never tried this. Can you post some code from your DTS package? I'll take a look tomorrow.
Steve Jones
October 18, 2001 at 6:26 pm
You have a few options.
1. Trigger - Can run more SQL statements. However, the transaction does not complete until the statement comepletes. Be careful with this.
2. Replicate the record
3. Use...
October 18, 2001 at 6:24 pm
Viewing 15 posts - 39,181 through 39,195 (of 39,456 total)