Viewing 15 posts - 526 through 540 (of 966 total)
Do you have enough space on the source server to hold the database twice? If so you could try the following:
- Backup the database you want to put on the...
December 5, 2012 at 8:33 am
Can you upload the setup log from the failed edition upgrade? Also, just to verify, you did select Edition Upgrade from the setup menu, and not a new install, right?
December 5, 2012 at 8:30 am
Hemant.R (12/5/2012)
--------------------------------------------------------------------------------
but if you are running maintainance plan for backup job then it is necessary that intergartion service in running state .
if it not started then your job will fail.
If...
December 5, 2012 at 5:37 am
Cross join or cross apply? A cross join produces a cartesian products whereas a cross apply applies the values of a result set to a table-valued function.
December 5, 2012 at 5:07 am
I second what Anthony said. Your "Connection" field at the top of the maintenance plan window is blank. You need to specify your SQL instance (I would not browse for...
December 5, 2012 at 4:58 am
Does the account that SQL was setup as have permissions to the location where you put the MDF file?
December 3, 2012 at 2:19 pm
Did you connect to the publisher/subscriber instances from SSMS with the account that you are using to setup merge replication?
December 3, 2012 at 2:03 pm
I believe the MSDAORA provider is for 32-bit systems
Speaking of MSDAORA, isn't that provider no longer supported? I thought it was meant only for Oracle 8i systems and below. It...
December 3, 2012 at 1:40 pm
You can view the sys.dm_os_waiting_tasks on a periodic basis and see what waits are going on and document them over time to determine if there are a lot of waits...
November 29, 2012 at 3:10 am
It sounds like a disk issue. How is your storage subsystem setup, and where are data, log and tempdb files stored?
What do you see from the sys.dm_os_waiting_tasks DMV?
November 29, 2012 at 3:02 am
Don't forget to rename the logical names of the db files for your mastercopy database. It should not cause problems if you do not, but if do anything with SQL...
November 28, 2012 at 8:10 am
So if the cluster was taken offline in the wrong way (i.e. the resources were not brought up on another cluster node and it was not able to failover automatically)...
November 28, 2012 at 8:04 am
if suppose some one deleted log when services are offline. then what is the process to make SQL services online again.
Which logs are you talking about? Database log files or...
November 28, 2012 at 7:11 am
Previous post reported as spam.
For the OP's issue, it looks like there the is a system latch on the database preventing the snapshot from occurring at that time. Can you...
November 28, 2012 at 6:13 am
How where the machines restarted? A cluster is all about high availabilty, so all nodes in a cluster should not be turned off within the same timeframe if it can...
November 28, 2012 at 6:09 am
Viewing 15 posts - 526 through 540 (of 966 total)