• SQL Server data purging

    I hv a trans tbl and want to keep the records to be purged on Tape/Media and read the data from there whenever required? I want to know, Is that possible to read data from the tape ? if so, then how to do it, neee help

    Taheer725 pointsBadges:
  • SQL Server 2005 SP2 backup failing

    This is my first post and thanks in advance for any replies. I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been, "BackupMedium::ReportIoError: write failure on backup device...

    Ajf10 pointsBadges:
  • SQL Server 2008 Export data problem

    Hi I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty db on the local machine. Then I scripted the...

    Tsp196520 pointsBadges:
  • Trouble backing up our SQL Server transaction logs

    Our SQL Server transaction logs have not been backing up, and I discovered it’s because a database was not selected in the maintenance plan. When I select the database and save it, however, it is not saving. It keeps reverting back to the previous option. Does anyone know why?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Scheduling a Shrink Database in SQL Server 2000

    Is there a way to schedule a shrink database after the transaction log has been backed up for a database via the maintenance plan?

    Jauner5 pointsBadges:
  • Can you backup a SQL Server 7.0 database while users are using the database?

    I know you can back up SQL Server 2000 databases while users are using the database, and I am certain that you can do the same for SQL Server 7.0, but I want confirmation if someone does not mind.

    Bkr0963c0 pointsBadges:
  • sql server backups

    how to take regular backups of sql scripts daily in sql server.. thanks in advance

    Manickam0 pointsBadges:
  • SQL Backup File Issue

    Hello, I am implementing a backup procedure for our SQL databases running Microsoft SQL Server 2000 ? 8.00.2039 on Windows Server 2003 Enterprise Edition. I have done so through a DB maintenance job. I am saving the backup as a file to a custom location on the same server. I also have the job...

    Jason119990 pointsBadges:
  • Recovery models for SQL Server databases

    What are acceptable recovery models for the Master and MSDB databases?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql server 2005 mirroring

    i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

    RaulZ5 pointsBadges:
  • EMC Network Backup Client/Agent backup for SQL 2000/2005 databases on Polyserve Matrix

    Hi, I am new with running SQL 2000/2005 instances on Polyserve Matrix servers. We use EMC Network as a corporate backup strategy. Can someone tell me will there be any problems using this backup tool for SQL instances on the Polyserve Matrix?

    Davidvoo5 pointsBadges:
  • Backing up and upgrading a SQL Server 2000 database

    We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server database backup (URGENT)

    Hi I have a db backup requirement. As shown in the attached image current system is as follows: There are three source databases such as DB001, DB002 and DB003. Each DB having one table as dbo.EMP and same table schema. Emp table consists of EmpID (PK) and EmpName. One backup database i.e, DBbackup...

    Plugsharma40 pointsBadges:
  • SQL Server restore duration

    what DMV show restore info. including the duration of a restore?

    JDPhillips5 pointsBadges:
  • SQL database backup

    Am having 2 databases running on SQL SERVER 2000, OS(windows server 2003), so the backup for these databases are to suppose to run on monday, wednesday and friday 12:00 and 16:30 in the afternoons.So since last week the backups have been failing to run till today, and by checking the event viewer,...

    45115 pointsBadges:
  • Backing up SQL Server 2005

    Where can I find information on backing up SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring to the end of a log backup in SQL Server bulk-logged recovery mode

    In bulk-logged recovery mode in SQL Server, how can you restore to the end of a log backup that includes a bulk event? It seems to me that everything after the bulk event is useless. How could I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to backup a SQL Server on a different Domain.

    We have just upgraded our admin server, which has an SQL database running on it. This server is also on a different domain from the backup server, which is running Backup Exec 12. Has anyone got any ideas on how we can connect to this server from the backup server that is on a different domain ?

    YodaTrueOne20 pointsBadges:
  • Error message during SQL Server backup

    We have a backup command that runs from within a command job on SQL Server A, and extracts data from SQL Servers B, C, D at different times to create a file on a SAN Drive. This is a daily job and runs successfully. Over the last fortnight, we have got the following error once for each different...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVER 2005 MAINTENANCE PLAN PROBLEM

    HI, SQL2K5 Maintenance plan does not delete old backups even when 'backups older than 1 days' is selected.so my backups are piling up and have to remove them manulally everyday. any solution? Marshall

    Marshall01275 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