SQL Server Backup

Unable to Restore Backup in SQL Server 2005

I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," &...

SQL Server DB Backup

Hello, I am a new member and would like assistance understanding why when I attempt to schedule a SQL Backup it doesn't seem to stick after I close and reopen it. I am doing the following: Windows Server 2003 – Enterprise Edition/SQL Vs. 8 1. SQL Enterprise Manager 2. SQL Server Group 3. Open...

Restoring SQL Server 2000 database

I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error 'You must select a backup set to restore'. Why is this and how do I resolve it?

schedule a restore plan

using sql 2005, management studio,, how to schedule a daily database and restore plan.

How do my database sql2005 database to another server with management studio

Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

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?

Error when restoring a .bak file in SQL Server

I’m having a problem restoring a .bak file in SQL Server. The .bak file is fine and good. But when I restore it, I get an error. It says " TITLE: Restore failed for Server <servername>(Microsoft.SqlServer.Smo) ------------------------------ ADDITIONAL INFORMATION: ...

How to back up SQL Server database file on a different shared network

I want to back up a SQL Server database file on a different system shared folder which is in different WAN network. How can I do this and are there any other backup methods available in SQL Server?

How to set up a threshold on a SQL Server 2000 Agent backup job?

I would like advice on setting up a threshold if a SQL Server 2000 Agent backup job (nightly) is running after a certain time (7 a.m. PST), I would like to cancel it.

Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

How can I take a backup of a SQL Server stored procedure only?

How can I take a backup of a SQL Server stored procedure only?

HOw do I restore a database from a backup in MS SQL Server 2000

I have no knowledge of MS SQL Server. Have software (BOOMI) that uses a database in this. I found a folder where the database is being backed up. i.e. there is a *.BAK file and hourly logs *.TRN. I need to update the boomi software and they say I need to make a back up of the database. If this is...

How can I restore a database from .mdf file? I only have .mdf backup file.

How can I restore a database from .mdf file? I only have .mdf backup file.

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?

documents on sql server upgrade from 2000 to 2005

Hello, If anyone has following documentation on SQL SERVER UPGRADE FROM 2000 TO SQL SERVER 2005, I will appreciate. 1) Pre-Checklist for the Upgrade 2) Process for the Upgrade 3) Post Check list for the Upgrade Thank you so much. If you kindly email me at cqldba@gmail.com, will appreciate thanks...

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

sql server backups

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

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.