Viewing 14 posts - 31 through 44 (of 44 total)
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...
December 30, 2009 at 8:09 am
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...
February 11, 2009 at 10:15 am
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....
February 11, 2009 at 9:52 am
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...
March 28, 2008 at 9:05 am
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...
March 26, 2008 at 2:50 pm
Thanks very much for your info.
September 18, 2006 at 2:58 pm
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...
October 17, 2005 at 11:41 am
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...
September 21, 2005 at 12:46 pm
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...
September 19, 2005 at 12:17 pm
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...
March 30, 2004 at 9:05 am
Allen,
Thanks a lot! It works!
Yichang
August 28, 2003 at 10:08 am
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...
June 26, 2002 at 10:07 am
A local drive with about 7 GB empty space.
June 25, 2002 at 3:09 pm
Hi,
The db was restored successfully with or without transaction logs. I was able to select after restore.
June 12, 2002 at 8:45 am
Viewing 14 posts - 31 through 44 (of 44 total)