Search results for query: *

hi there, I have a server running NT 4 (SP6a) and SQL Server 7 (without service pack). I am reliazed that sqlservr.exe occupied alot of memory and never release after been used. Is it a bugs of MS SQL Server 7 ? Or is it the nature of SQL Server 7 ? I am planning to upgrade the SQL Server...

Hello Dan, thankx for ur reply. I know that I can use the following function to initiate a "Print Preview" function in IE6, but is it posible to use the same function on the frameset. In other words when this function is used on the pages with frames it shows the whole frameset...

Dan, thankx for ur reply. I had tried, but still give me the same result. May be you can copy the above function into a frame and try from it. Appreciate if you can help me.

Yup, is a frame that contain the above function. Then i trying to click on a button, it will call the printpr function. do you get what i meant ?

Hi, i trying to use print preview in my asp page contain 3 frames. I using the following function, I able to do the print preview. But it is always default to "As laid out on Screen". How can i modify the following function so that it can set it to "Only the Selected...

You are not able to backup the transaction log if you turn it to SIMPLE mode. Anything happen to ur server, you are only able to restore the last backup information. If you not sure about SIMPLE mode, please use FULL mode. And try to backup the transaction log as often as possible. In case...

thankx J.Kusch, the article very useful.

Hi, "Attempt to repair any minor problems" in the database Integrity Check". May i know what are the minor problems meants ? How the SQL Server repair it ? Thank you!

Hi Nigel and SQLBill, Recently i did a restore a backup database. But realized that my application program response very slow. I suspect is the indexing problems. I did some indexing in the database before it crash. Do i need to restore the master database also ? Because i read some...

Hi Nigel and SQLBill, Really thank you for your helps.

Can i delete the transaction log file (LDF) using below menthod : Detach database Delete the Transaction Log Attach database System will create a new transaction log with minimum size. Any impact to MDF if i follow above menthod?

Hi all, Thank you very much! I got the information from BOL.

Yup, i want to take the tr log backups. Any recommendation menthods for shrinking the LDF file ? What are the adverse effect ? Appreciate if you share with me. Thank you!

Hi, I have a database contain 1 LDF in 3G, but MDF only 1G. Can i shrink the LDF file to 1M? How to do it ? What is the impact to MDF if i shrink the LDF ? Thank you!

Hi Ecobb, What is the different for the recovery model ? Simple, Full and Bulk-Logged? Any impact if i selected Simple Model ? Thankx

Thankx nigelrivett, How do i check wether my SQL Server is under Simple Recovery mode, bulk logged or fully recovery mode ? If i have the full backup copy, do i need to keep a copy of transaction log ?

Hi, I'm new SQL database administrator. May i know how MS SQL Server Transaction Log works ? Is it every time when the COMMIT statement issues, SQL Server will write the data in the database file ? How come after i did the full backup, my LDF file size not reduce? I thought SQL Server...