• SQK Server 2000 Database Size

    I am an Oracle DBA starting to learn SQL Server (as I am sure many are). I have databases that show a lot of free space when I look at Taskpad view. I read that a database cannot be shrunk below it's original creation size, how do I find that original creation size?

    Oradba130 pointsBadges:
  • SQL Server Install

    I just installed SQL Server 2000 on a brand new Windows 2000 SP4 server. The install did not prompt me for the CD-Key! Does anyone know why this would happen?

    Oradba130 pointsBadges:
  • DTS FTP taks with proxy server

    Hi all. Our institution has FTP traffic going through a proxy server. I can get here ftp://ftp.geneontology.org/pub/go/doc/GO.xrf_abbs just fine through Internet Explorer but NOT using an FTP task in DTS. So... does the FTP task basically ignore your IE connection settings? Thanks for info.

    Hopkihc0 pointsBadges:
  • best practice for SQL Agent account security

    Hello... kind of a "newbie" question here, but appreciate the insight. In order to bring our systems in line with best practices, I'm changing a couple of SQL instances from running under LocalSystem to running under a specific account. Same goes for the SQL Agent. Note that these accounts are...

    Hopkihc0 pointsBadges:
  • Creating a Sequence of Transaction Log Backups

    What is the best practices for creating daily (hourly) transcation log backups? Option 1: Create individual jobs for each hour written to individual backup files? Example: log0800am.bak log0900am.bak log1000am.bak so forth Option 2: Create two jobs: (1) first job initiates backup file WITH INIT;...

    Ericggordon0 pointsBadges:
  • SQL Server Books

    I am an Oracle DBA learning SQL Server. Does anyone have any favorite books for SQL Server 2000. I am looking specifically for books geared towards everyday tasks performed by a DBA.

    Oradba130 pointsBadges:
  • SAP and database maintenance (SQL Server DBMS)

    We have a SAP R/3 application that is running on Microsoft's SQL Server DBMS. According to all DBA experience that I have had, there are standard practices to maintain performance of an OLTP database. Things like managing fragmentation and index re-organizing. Our SAP support is telling us that...

    Cecrane10 pointsBadges:
  • SQL Server 2000 log shipping through a firewall

    Has anyone implemented log shipping in SQL Server 2000 between 2 servers separated by a firewall? If so, what (if any) modifications did you have to make for this?

    Rsuggs0 pointsBadges:
  • Encryption in the Database

    Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?

    Dw499990 pointsBadges:
  • Hosting SMS in SQL Server

    I am one of a group of DBAs who have done and continue to do Oracle work for several years. We having also been taking on SQL Server databases since last fall. We have attempted to establish a standardized environment for each SQL Server instance and database to facilitate maintenance, backup and...

    Jrmills0 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