I dont think you need to restore system databases to make a copy of production. Because Dev and Prod are completely different instances.

Dev and prod need to match with their...

Did you say you restored the dev server system databases with the backup from production system databases?

Thanks!!

You would need to do this then, won't affect anything else unless you have any jobs that use the old server name. If so you need to updated them with...

You can do so by changing the name of your server from windows OS. Then restart SQL server. Your new name should reflect when you run select @@servername again.

Thanks!!

Steve asked you to check if the fill factor is a small value like 40 or 50 % if so please make it 80 or 90% that means all the...

Decrease the Autogrow from100MB to say 10% or a smaller size in MB. Also allocate a larger file size to begin with that way the transaction will not have ...

You can try these books if you want.

http://cid-1cc1edb3daa9b8aa.profile.live.com/Lists/cns!1CC1EDB3DAA9B8AA!203/

They are what they are...:P

Thanks!!

Scott,

In the properties tab you say it is displaying 100MB growth restricted to 2,097,152. I think that is the maximum space available on the drive.

Unlimited filegrowth is only in the...

Even though you are the owner of the job but the process that kicks of the job is SQLAgent service. I think it is not able to access that folder...

Do you have backup files older than 2 days in that directory?

Thanks!!

If the linked server is on ServerA then the security should be set as 'Be made using this security context ', here specify the login and password that exists on...

As for the link for SQL 2005 Clustering, there is a good article by Richard Lu, you can refer it in the below link

http://www.sqlservercentral.com/articles/Clustering/62327/

Thanks!!

You can manage a cluster through Cluster Administrator only. This is available when you install MSCS ( Microsoft Clustering Services) on the windows server. This will enable you to list...

Right click on the server and go to properties. Click on the Connections tab on left and there the first option is to set the max allowed connections.

The default is...

Make sure the account specified in the linked server has required credentials to access the database on server B

Thanks!!