Hi,

1.Create a job take a backup of the database on Server A

2.Create a job on Server A to Copy the backup to share in the B.

3.Create a job to restore...

SQL has a feature to use all the memory in the Server.

If this server is not dedicated(this always hosts the APP or batch processes) then limit the maximum server memory...

You can download the upgrade advisor from the following location. It has both 64 and 32 bit versions.

http://www.scalabilityexperts.com/tools/downloads.html

With express edition you can do Subscription.

I have an environment where we have to create a custom replication along with client side application. With that we have saved more than...

Thank you all for your suggestion. I will recheck those suggestions again.

Whole server is running on an isolated environment. From SQL server side there is no SA permissions for application...

Power shall is the best option to traverse the folder and generate the scripts.

in case if If you are using the 3rd party backup software then we don't require...

you can send the mail using sp_send_dbmail this simplest way.

Syntax:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'XXXX',

@recipients = 'XXX@XXX.com',

@body = 'The stored...

Since you are trying to restore the DB on the same server and both source and destination databases exist exist in the same location. Its trying to recreate/restore the same...

By default; the named instances including SQL Server 2005 Express Edition listen on dynamic ports. That's the reason you need to start the browser service on named instances and express...

Based on my experience; I have used single VM processor and 2GB ram, for a small databases (Less than 3-5 GB) where user base is less 10 to 20 users...

If you have permissions then create an another user called saadmin and provide the systemadmin permissions to that account. login using systemadmin account, if no applications/connection strings are using then...

You can do the task in multiple ways. After doing some analysis, I found that following method is simplest way to refresh the databases from production to test on daily...

Shutdown process:

1.Other way You can stop the SQL Services on Node A, actually shutting down the cluster stops the SQL Services.

2.Shut down the Node A

3.Then Shut down the Node.

Restart...

The following scenarios in general I would recommend to reboot the machine.

1.After the SQL Server patches and Service Pack updates.

2.Windows Quarterly Patches or security updates.

3.Any server maintenance tasks.

4.Firmware upgrades and...

I have seen the issues when very large/complex processing is going on the database servers. If the code generates lots of temporary data then tempdb will grow.

If the server is...