Viewing 15 posts - 1,636 through 1,650 (of 2,387 total)
Create a batch program that calls OSQL.EXE to alter your MSDB recovery mode. Use SC.EXE to configure the batch program as a service with automaticallt starting. And the configure this...
June 12, 2003 at 4:33 pm
Where did you get this error? You may look SQL command 'SET DATEFORMAT' in BOL.
June 12, 2003 at 2:26 pm
From DOS.
C:\OSQL.exe -Syourservername -E
Once you login to SQL Server, Run following statemnet.
>backup database yourdbname to disk = 'c:\temp\yourdbname_date.bak'
June 12, 2003 at 2:24 pm
In an active/passive failover configuration, there is only one instance of SQL Server running on the cluster. So if a failover should occur, the secondary server will take over once...
June 12, 2003 at 2:03 pm
Once you install second instance, it will be active/active. If you license SQL Server by number CPUs, I don't think you need additional licence but you better check with Microsoft...
June 12, 2003 at 1:11 pm
I wouldn't concern about it because it lasts only about 30 seconds. I think the high CPUs usage may caused by your report.
If you don't have large number user...
June 12, 2003 at 1:06 pm
How long the high CPU usage lasts? Any jobs/programs scheduled to start at 12:00AM?
June 12, 2003 at 11:58 am
Quoted from BOL about the definition of instance.
"There are two types of instances of SQL Server:
Default Instances
The default instance of the SQL Server 2000 database engine operates the same way...
June 11, 2003 at 3:45 pm
quote:
only one that running named instance is not working.
Try isql.exe -Ststsql01\tst (Replace tstsql01...
June 11, 2003 at 12:08 pm
Is Tempdb allowed to automatically grow? What is the file growth increment setting? Set the original size of the tempdb database files to a reasonable size to avoid the files...
June 10, 2003 at 10:33 pm
SQL Server has to be configured with 'windows and SQL Server' authentication. You can do it from EM --> Propereties --> security tab.
June 10, 2003 at 10:12 pm
Create linked server in local server to the remote server and call the SP using four part naming convention.
June 10, 2003 at 9:56 pm
Certainly you can. Both Clustered SQL Server instances can run on same node or in different nodes.
June 10, 2003 at 2:44 pm
Any errors in application/system logs in all nodes?
June 10, 2003 at 2:39 pm
Viewing 15 posts - 1,636 through 1,650 (of 2,387 total)