• Setting up database mirroring for disaster recovery in SQL Server

    I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, how do I make sure...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Keyboard

    Hi - I have three characters missing from my 2 year old Toshiba laptop keyboard. Is there any way I can retrieve them, please. One of them is the question mark!

    Ginnyivor10 pointsBadges:
  • Restoring a SQL Server 2005 database from a public share backup

    Is it true that even in SQL Server 2005 you cannot restore a database from a backup on a public share, but ONLY from a local storage (DASD)drive?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server restore job fails

    I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...

    TuftsDBA0 pointsBadges:
  • Backup Programmability in SQL Server 2005

    How can I backup the Programmability (functions, triggers stored procedures etc.) as part of a schedule job? Do I need to write code or can I use the wizard?

    IT Systems Analyst15 pointsBadges:
  • Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2

    Hi... We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT expertise to build or maintain, and will deliver maximum...

    Mmosystem0 pointsBadges:
  • Need help setting Transaction Log properties in SQL Server 2000

    I'd like some help determining what would be the best settings for my transaction log properties. When our SQL Server 2000 SP4 Database was setup it was done by developers without detailed information regarding all of the possible settings so most settings were left at their defaults. I have been...

    KansasCoder40 pointsBadges:
  • Lotus Notes replication

    Why does Lotus Notes not replicate to local?

    Pushpn5 pointsBadges:
  • Storing a file in a database versus the file system?

    Performance-wise is there a big difference between storing a file in a database (e.g., mssql) versus the system? It sees to me that outside of application portability I would want to store my files as varbinaries in SQL Server?

    ITKE352,565 pointsBadges:
  • Moving DASD Between LPAR’s

    Folks, Just want to know while moving the disks between LPAR's, Do I have to move the cache card also? CMB08 575C-001 Operational Storage Controller DC04 575C-001 Operational Storage Controller CMB07 575C-001 Operational Storage Controller DC05 575C-001 Operational Storage Controller CMB10 575C-001...

    Mani1017130 pointsBadges:
  • Why unique FCID is needed when WWN is also unique?

    Hi,I have a basic question. This was asked to me on an interview for which i was not able to answer. Q: WWN is a 64 bit unique identifier and is given for each port and node and also for switches.Why do we need an seperate FCID in fibre channel when we have a unquie WWN. Why cannot we use the WWN...

    facebookbharathi5 pointsBadges:
  • Excel.exe process is getting struck in task manager and it’s not closing even the session is end

    Hi, My code is invoking Excel process to generate the report and that is killing once the process is completed. But sometime, couple of Excel.exe process is getting struck even the session is ended. Which is causing NFS memory full. Please advise me of what the the root cause to this issue is. By...

    FIRSTSCHOOL5 pointsBadges:
  • How to check brbackup status

    How to check the status of offline backup in brtools

    PrashAB5 pointsBadges:
  • Database all about RAID introduction including annotated diagrams

    Can someone help me with this question: RAID Levels, Hardware issues,choice of RAID level and improvement in performance via parallelism

    cos5 pointsBadges:
  • Mount Windows Partition in Ubuntu

    I installed Ubuntu onto a WinXPP machine so that they are duo boot. The system should have automatically mounted my windows directory and created an icon on the desktop. It did not. I followed the directions and opened a bash shell and typed sudo vol_id -u /dev/sda1 Ubuntu returns the error command...

    Hsmithdp125 pointsBadges:
  • San Mount Volume Changed HELP!!!

    I run a system comprised of 36 IBM Blade servers, a Hitachi 64TB SAN, a Data Domain backup suite and connection devices. I run Windows 2003 R2 (32bit) and Red Hat 4 (64bit). I have just come across a problem in that all the windows blades in one (of three) chassis are displaying my drive E: (which...

    GMB8635 pointsBadges:
  • Secondary storage for the future

    Does anyone have some examples of advancement in secondary storage for the future?

    winsonloseson5 pointsBadges:
  • Does SQL Server 2014 backup to early versions of SQL Server?

    I’m looking to go up to SQL Server 2014 version and am testing a large database to handle it. Is there any way restore SQL Server 2014 backup in SQL Server 2008? I know it’s possible to restore SQL Server 2008 backup in SQL Server 2005, but was removed in 2012 to 2008. Has this been restored in...

    ITKE352,565 pointsBadges:
  • Comments in Excel using VBA with archived info included

    To whom it may concern,I am currently trying to get very specific cells in a spreadsheet to pull up the previous weeks worth of information (date from the past 5 days at least) and to show up in a comment on very specific cells so that the people in my department do not have to look up the...

    jgarces5 pointsBadges:
  • Corrupted Hard Disk Drive

    Have HP Pavilion a430n; 1GB RAM; 320GB HDD; Windows 7. Tried downloading and installing Linux/Ubuntu OS. This didn't happen. Now the HDD is not accessible except for an attempt to boot. It goes as far as a desktop without the icons then goes directly into re-install windows, with disc inserted, but...

    Canhandleit135 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following