Viewing 15 posts - 421 through 435 (of 462 total)
Both have their own advantages:
Backup : If you have only one table which is big, backup might be a better option. One of the reason being that you can query...
March 12, 2003 at 9:35 pm
Not tried that. But don't think it should be an issue. I have deleted entries from active directory when i was building a cluster and had to rebuild the cluster...
March 3, 2003 at 6:07 pm
Bill,
During install of SQL Server, the virtual name of sql server does get added to Active Directory. Not sure whether this did answer your question or not and if not...
February 25, 2003 at 4:49 pm
I'm sure the entry for the cluster gets added in the Active Directory on its own when you create a cluster but not sure for SQL Server. I'll check it...
February 20, 2003 at 9:43 pm
Below is the link for a script which shrinks log.
http://www.sqlservercentral.com/scripts/contributions/26.asp
February 20, 2003 at 9:40 pm
There is a great script for shrinking databases on this website and it works great both for SQL 7.0/2000(some changes need to be done for SQL 2000. I'm not sure...
February 20, 2003 at 9:32 pm
Dave,
I'm not sure why you can't query sysfiles database but if you replace sysfiles to sysfiles1,it would work.It did work for me. BOL says that sysfiles is a virtual table...
February 15, 2003 at 4:51 pm
Execellent article. I don't think BOL has also covered this basics.
February 13, 2003 at 10:23 am
Not Sure, But we are building a new cluster right now and if you can wait for a couple of days, i hope i would be done by tomorrow and...
February 3, 2003 at 12:50 pm
We had a simillar problem but in our case the remote firewall was not responding. Can you try to telnet on port 1433(or whatever port the remote server is listening)...
February 3, 2003 at 12:47 pm
Jay,
Not sure why you are having problems. But what i might do is query the sysprocesses table in master database. And then run dbcc inputbuffer(spid)(where spid is the id of...
February 2, 2003 at 6:30 pm
Franco,
Prior to SP3, when you use DTS to transfer objects(not data), the database would be but into simple mode as you mentioned. Due to this, you will have to take...
January 31, 2003 at 11:20 am
Quite Simillar to the above. The only change being we push our backups to tape immediately (Add a step in the job).
January 17, 2003 at 9:24 pm
The feature of two active database on a cluster is an oracle feature. The understanding which you are having is correct and that's how the oracle cluster works. but...
January 15, 2003 at 5:57 pm
Viewing 15 posts - 421 through 435 (of 462 total)