Hi,

I find no answer for this. I even posted the same in MSDN and there was none to answer. Have i asked a question that was wrong? Anyways after much...

I dont have a script but the commands are as given below.

move <<SOURCEpath>>\filename <<DESTINATIONPATH>>\filename

rename <<SOURCEPATH>>\filename filename

the first will move the file to the destination location adn the second will rename...

Check if you have quotas enabled in the server and if that limits the space that you can use.

Can you be more specific whats the reports that you want?

This is ofcourse undocumented but for sure will rebuild the msdb database without having to rebuild your sql server system.

Microsoft does not say this. But i hope scroable question should be only 40 and not 50. It would have taken the wrong ones and you should have failed. better...

Is the /3GB switch set. Can you monitor the memory used by SQL Server using perfmon counters and see at what time this error occurs. I suspect some incorrect setting...

If your tape backup is running daily then you can place the backups on disk and then take the files to tape so that they are consitent enough. Yuo too...

I am not clear with your question. Do you want to know if the schedule is ok to be implemented or do you want to have a script that will...

When you login to the server using local. Check what is the server name using select @@servername

if this is not consistent then

use sp_dropserver and sp_addserver to add the server...

You want to limit the table in profiler that can be done. Filter it by objectname column like

('%table1%,'%table2%',.......................,'tablen%')

DataSource should be the name of the server and Initial Catalog will be the name of the database in the connection string. The database will have your mdf, ldf and...

As Sachin suggested yo can go to read the log file. But you have to have the database in FULL recovery model to have all transaction in the log file.

But you will be able to shrink only the unused log file space if suppose the log file is being heavily used and if you are not able to shrink...

ok There is some misunderstanding somewhere anyways no issues. But the first post from Rahul on this topic ask for that. Just confirmed thanks that the before and after image...