Viewing 15 posts - 76 through 90 (of 433 total)
It is very simple. First remove passive node and then unistall the primary instance.
"More Green More Oxygen !! Plant a tree today"
May 12, 2011 at 10:43 pm
If this is with only one single database? I think there is some issue with database. Check the SQL Server error log what does that say? Run DBCC CHECKDB on...
"More Green More Oxygen !! Plant a tree today"
April 22, 2011 at 2:03 am
You could have specified the environment detail, what type of IO you are expecting etc this clould have helped us in answering your query.
"More Green More Oxygen !! Plant a tree today"
April 18, 2011 at 4:50 am
First let me caution you for having data & log file on network drive. As said by Gail Shaw
this will impact perf as well as data corruption and IO issues....
"More Green More Oxygen !! Plant a tree today"
April 18, 2011 at 4:37 am
TST1 (4/14/2011)
I'm doing a sql cluster 2008 install on win2k8. I have 3 disks partitioned for data, backup and dtc. During the installation of DTC, I have noticed...
"More Green More Oxygen !! Plant a tree today"
April 18, 2011 at 4:08 am
Yes AD plays a very IMP role in cluster setup. You need to run the valid cluster and until the report given you aclean go you will face issues.
"More Green More Oxygen !! Plant a tree today"
April 18, 2011 at 4:05 am
Find out if your windows account and SQL Service have access to the network location and if this windows 2008 server then you have to be the owner of the...
"More Green More Oxygen !! Plant a tree today"
April 18, 2011 at 3:51 am
I think it is unlimited number of secondaries for each primary database.
"More Green More Oxygen !! Plant a tree today"
February 7, 2011 at 9:22 pm
tacy.highland (2/1/2011)
I've set up logshipping between primary server and secondary server, with the log files being saved to a shared folder on another...
"More Green More Oxygen !! Plant a tree today"
February 7, 2011 at 8:57 pm
There will be a heavy load on SQL Server as all the application will access it. What is the current SQL Server configuration ? What configuration you are planning for...
"More Green More Oxygen !! Plant a tree today"
February 7, 2011 at 8:42 pm
When you have two instances on the same system one will be the default and other will be the Named instance unless you specifify both to be Named Instance.
Default instance...
"More Green More Oxygen !! Plant a tree today"
February 7, 2011 at 8:34 pm
Maxer (2/4/2011)
Is an ETL package in SSIS a better option here?
I think so, you can map the table columns and pump the data into it.
"More Green More Oxygen !! Plant a tree today"
February 7, 2011 at 8:21 pm
kalrpuli (9/17/2010)
which statement true of the MSDB databse(1)MSDB is useful in SQLSEVER AGENT
(2)im MSDB database jobs executed automatically
(3)both are true
(4)none of statement true
This is a professional forum appreciate if the...
"More Green More Oxygen !! Plant a tree today"
September 17, 2010 at 7:56 am
Please follow the advice as Roy pointed out to zip the backup file while transfering and then try restoring the backup.
We had similar issue in out Stage server and...
"More Green More Oxygen !! Plant a tree today"
September 17, 2010 at 7:46 am
Is that a default instance or named instance, Did you try explicitly typing the instance name and connecting to it.
Is this a express edition?
What does the error log say?...
"More Green More Oxygen !! Plant a tree today"
September 17, 2010 at 7:37 am
Viewing 15 posts - 76 through 90 (of 433 total)