Viewing 15 posts - 1,051 through 1,065 (of 2,387 total)
With the /3GB enabled, system will allocate 3GB for applications including SQL Serevr and leave itself 1GB. It also uses memeory within 1GB to manage the memory that is beyond...
October 3, 2003 at 10:10 pm
It happens to one of my SQL Server when scheduled job tries to load large amount of data from text file into a partitioned table. We found out that "SCSI...
October 3, 2003 at 10:02 pm
I guess my database can be considered as medium/large. It is 550GB in allocated spaces and over 500GB in use currently. It is SAP R3 OLTP database and increase at...
October 2, 2003 at 8:03 pm
You are right. I should say script all objects from your original database and create them in SQL Server 7.0 database, BCP data out from SQL Server 2000 database and...
October 2, 2003 at 7:34 pm
In the DTS import wizard --> select source tables and views --> change the object owner to 'dbo' in destination column, the table you import will be owned by 'dbo'....
October 2, 2003 at 7:31 pm
You can set database in 'simple recovery' mode to let system to truncate the log file if your database doesn't need to be recovered to the point of failure or...
October 2, 2003 at 2:59 pm
quote:
Here's the first facet:Lets say you have a SQL server registered on DOMAINX (an NT Domain). Lets say you have a...
October 2, 2003 at 2:36 pm
quote:
Or I can safely say, this was just a backup failure, the next backup picked up everything and no data was...
October 2, 2003 at 2:08 pm
quote:
The question I have that what will happen if sql server uses up all 1.5GB?
October 2, 2003 at 1:07 pm
Yes, there are MDF and LDF files. sp_helpfile will tell you all those files your database has.
October 2, 2003 at 12:23 pm
Once database restored, script all triggers, replace all db name at once, and recreate them. It shouldn't be too much work.
October 2, 2003 at 12:21 pm
To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege....
October 2, 2003 at 12:13 pm
Viewing 15 posts - 1,051 through 1,065 (of 2,387 total)