Hi,

Reporting Services configuration manager can assist you in creating the reportserver abd reportservertempdb databases for you.

the requirements for this are as follow. A sql server instance where you can host...

I have used Profiler as well. I have checked all counters available on the server.

there are a lot of full scans going on. every day the avareage full scan is...

Restart the MSSQSERVER services which will reset the tempdb file sizes to its original size. then try enabling auto grow using MB instead of % basis. also keep performing transactinal...

Not sure if this is what you were looking for.

the script in the following link should help you up to an extent.

http://www.sqlservercentral.com/scripts/Audit/61175/

Regards,

Sathya.

Yes it is Possible.

You need to have a shared network drive on serverB. use this drive to store your backup.

Make sure the drive has all access permissions to both...

If you have the Local Admin rights on your server machine and you are using windows login to connect to the sql server you should be able to delete the...

Hi Ninja_RGR'us,

- I have checked the auto-close and auto-shrink options and they are disabled.

- there is also no disk contention for TEMPDB.

- the slowness of the application : it takes...

Thank you all for the help.

My problem is solved. Had it not been for you guys i would have been stuck.

I had the .BAK file on a network Drive. i...

The DB is on SQL server 2000. when the Actual DB was available it used to take about 1 HOUR

to restore the full backup. will it be 12 hours before...

Hello evryone,

I'm going to take my MCTS 70-431 exam next month.

How do i get to know the cost of this exam.

I have used the Microsoft self paced training kit for...

I have deleted every record pertainig to the old log shipping.

this is how i plan to reconfigure log shipping.

1.) take full backup of primary database.

2.) restore secondary DB using the...

Thank you Deepak,

I would have done what you have suggested but i am unable to find the .TUF file to load the transactions.

and one of my colleauge already removed...