1
  • sql 2008 export to txt for backup and incremental backup

    Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

    Jordaan5 pointsBadges:
  • How to use Insert command between two servers to speed up performance

    We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there....

    Studentofsql5 pointsBadges:
  • Large DB, low capacity line, resync log-shipping options.

    Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...

    SuperCoolMoss140 pointsBadges:
  • SQL DB MIRRORING ACROSS VPN?

    Can SQL 2005 DB mirroring work if the mirror server is to be in another building (building networks connected via VPN router)? We just want employees to be able to remote into the mirror server from home if power is lost at the main building.

    Kareemr695 pointsBadges:
  • How to move the msdb database to sql 2005

    I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I'm getting a compatability error message. Any suggestions greatly appreciated.

    Bubbanm90 pointsBadges:
  • Connecting to a remote DB on a UNIX server with SQL

    I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr * C Eval...

    AS400 - Ask the Expert485 pointsBadges:
  • MIgration to 64-bit Sql Server

    What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

    Tomfitzrugger5 pointsBadges:
  • Replication

    Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?

    Consultant16535 pointsBadges:
1

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