Thanks for your comment.

The approach discussed is to synchronize the login/userid of the report instance with the corresponding one in the read only database. The suggestion you made could work...

Assumed you first have database mail profile configured. You then need to enable it and associate it with the Operator (right-click SQL Server Agent > Properties > Alert System). Restart...

The approach you took to balance the data cross 8 files can achieve by:

1. Find out the newly-restored database file sizes

2. Make the original 4 data files the same size

3....

To move tempdb data files, you don't need to physically move the data files. Here is a straight procedure for the task:

1. Identify a suitable time to do it.

2. Run...

The indexes you mentioned seem to be created with higher fillfactors. Check these parameters for the indexes. If they are high, you can drop and recreate them with a lower...

Thanks very much for your info.

Here are a couple of metheds:

1. You can connect to your desktop in your primary office, then access to the SQL Server as what you usually do.

2. If you are...

SQL Server Port 1433 was enabled on the host server and A static IP was isigned to my remote PC. I got "Request time out" when pinging the server either by IP...

Thanks for your replies. Here is more info regarding the problem:

1. I created a login in the remote SQL Server.

2. The remote server is in Mixed Mode.

3. I tried to...

I used DTS to "restore" the database on development environment.

The source database was installed and configured by a third party vendor. I wonder why the database size was set to...

Allen,

Thanks a lot! It works!

Yichang

The backup is back to normal.

The disk is a true local drive. I specified the server's IP address as part of the physical backup files in both backup device and...

A local drive with about 7 GB empty space.

Hi,

The db was restored successfully with or without transaction logs. I was able to select after restore.