Forum Replies Created

Viewing 15 posts - 526 through 540 (of 966 total)

  • RE: Restore DB with actual data size

    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...

  • RE: Upgrade from SQL Server 2005 Standard to Enterprise

    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?

  • RE: Backup failing

    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...

  • RE: Major difference between cross join and inner join

    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.

    Using Cross Joins

    Using APPLY

  • RE: Backup failing

    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...

  • RE: Problem With AdventureWorks

    Does the account that SQL was setup as have permissions to the location where you put the MDF file?

  • RE: SQL merge replication

    Did you connect to the publisher/subscriber instances from SSMS with the account that you are using to setup merge replication?

  • RE: Data migration from sql to oracle

    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...

  • RE: Validating storage performance

    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...

  • RE: Virtualised SQL 2008 Performance Problem

    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?

  • RE: recover data from master backup file

    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...

  • RE: Dont find any logs

    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)...

  • RE: Dont find any logs

    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...

  • RE: BACKUP DATABASE is terminating abnormally

    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...

  • RE: Dont find any logs

    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...

Viewing 15 posts - 526 through 540 (of 966 total)