I am using SQL 7.0. Is anyone aware of a program to benchmark the performance of a server with no replication, snapshot replication and transactional replication
I have 3 (SQL 7.0) databases that are experiencing unreasonable transaction log file growth. Originally the database was set up 2GB data and 1GB log. Curently the log is 14GB. I have tried truncating the log, checking for open transactions and running various DBCC commands. The truncate...
SQL Server 2000 allows varchar greater than 255, however I am unable to return more that 255 in the select statement. I have verified that the table does accept and store the larger field size. Does anyone know how to return the full field on the select statement.
Traci
Did you install as a local database (on window 98 or 2000) or did you install on a server?
when you start enterprise manager do you try to register the database? Try registering the database and select servers. see if you machine shows. If it doesn't try entering the IP address for server...
Which log files are you referrinf to - errorlog, transaction log or backup log? if the database log is too large or not getting deleted properly, after performing a full database backup you can run dump trans XXXXX with truncate.
Using the Restore from file option you can grab the backup from any location. It doesn't have to be copied locally. However there are some occasional pitfalls....In SQL 7.0 the users are not always created properly on the new database. the logins get created but the sysusers table doesn't get...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.