Viewing 12 posts - 1 through 12 (of 12 total)
I have used DTS Backup2000 to copy the packages to another server without issues. I am sure this will work with the local instance as the target.
January 30, 2007 at 1:51 pm
Clunk,
I have run rebuildm over RDP numerous times without any issues.
HTH,
Glenn
November 1, 2005 at 10:44 pm
I agree with Phil regarding the idea of using the server to handle the backup process.
However, for adhoc backups via an application (ie backup the DB during the day...
October 17, 2005 at 5:40 pm
I have had the same problem reported by a couple of users last month. In the past they have been able to view all connections through EM. Now they get...
October 16, 2005 at 7:19 pm
Philip,
I have successfully done this twice in our environment with no issues.
Steps taken were to stop SQL. Copy all current DBs to another location. Uninstall SQL Enterprise. Install SQL Standard...
October 16, 2005 at 6:42 pm
Every system error 112 error I have seen is due to insufficient disk space - usually during backup operations.
You may find that the original database had a huge log file but...
September 21, 2005 at 5:04 am
Steve,
Changing this setting does not take affect until SQL is restarted (either the service or a server reboot)
This is a real headache as I have set this and had to...
September 7, 2005 at 6:31 am
There is another reason not to do this. If a user does not have a default database then they are unable to login to SQl. Period. Does not matter what...
August 17, 2005 at 6:38 am
For a local site implementation I would stick with MSCS - better support given for known configurations.
If you are looking at geographic clustering then you will have to look at...
August 2, 2005 at 6:21 pm
Terence,
Check out http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=131752
It is a little messy but dwilson4's post pretty much covers what is required.
If you have changed domains there may also be an issue with SIDs not matching....
July 20, 2005 at 5:30 am
Terry,
Does the account used for the MSSQLServer service have modify rights to the root drive that the data files are stored on? I have had a similar problem before where...
May 5, 2005 at 10:45 pm
FYI
Here is the string returned on a 64bit Itanium:
Microsoft SQL Server 2000 - 8.00.760 (Intel IA-64) Feb 6 2003 16:07:24 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) on Windows...
April 28, 2005 at 6:36 pm
Viewing 12 posts - 1 through 12 (of 12 total)