Is It Possible To Just Restore Particular Tables From A Back Up Of A Database

Jan 29, 2007

Hi,

  I backed my sql server database on Fri at 3:15pm and then tried importing some tables individually from a different database and but that didnt work out too good, so is there a way i can just restore particular tables from the backup.

any help will be appreciated.

regards,

Karen

View 4 Replies


ADVERTISEMENT

HELP!!! Can Not Restore Database From Only Back Up I Have

Jul 10, 2006

I had to transfer my database from one server to another. Both are running SQL 2000. I backed the database up and moved it to the new server however when I try to do a restore I get the following message:

The media set for database "xxx' has 2 family members but only 1 are provided. RESTORE DATABASE is terminating abnormally.

I did some searching and found a couple of posts that mentioned something about the back up including 2 files.

My problem is that the machine I backed this up from crashed when it was shut down and would not reboot so all of the data and the original database do not exist. Is there any hope of restoring this database. It is pretty critical.

Thanks,

Melissa :-)

View 20 Replies View Related

I Want To Revert Back To Original State Of Database Before I Performed Restore Database

Nov 15, 2006

Hello,i am in great trouble. I want to revert back to original state ofdatabase before i performed restore database on my sql server 2KDatabase. Accidently i didn't take backup of my Database and i didrestore, so is there any way to get the original state back of myDatabase?Any suggestion will be highly appriciated.Regards,S. Domadia.

View 2 Replies View Related

Need To Back Up A Database And Then Restore It On Another Server

May 18, 2007

I need to back up a production database on one server and then copy it to a test server wherel it will be restored. The problem is that I don't know where to move the  file to on the production server before I restore it. Is there a special folder I need to copy the file to? I see a folder named ProgramFilesMicrosoft SQL Server but beyond that I have no idea where to copy the file so that it can be restored?
 
Can someone help me out please?

View 1 Replies View Related

How Can Take Back-Up And Restore Database From A Web Form Wsing Asp.net(vb.net)

Aug 18, 2005

I want to give a facility to backup database restore database  to the customer in my project.

Database is stored in sql server 2000.

From the website the browser can take backup by clicking BACKUP button and
restore database by clicking RESTORE button.

is it possiable in asp.net programatically ?

View 3 Replies View Related

Need To Back Up && Restore A SQL Server Database When Only SQL 2000 And 2005 Are Available.

Oct 22, 2007

I am maintaining a .net 1.0 asp.net web application that accesses a SQL server 2000 database. I need to backup the database and then restore it on a laptop. Currently it resides on a server. The problem is that on the server they are using sql server 2005. If I backup using 2005 and then try and restore this database using SQL server 2000 or 2005 on the laptop, I get an error message. "Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE DATABASE is terminating abnormally.
What can I do to restore the database? Must it be backed up with SQL server 2000 and then restored with SQL Server 2005?
Please help!

View 1 Replies View Related

How Do I Restore Sql Server Database Primary Data Back .mdf

Feb 12, 2007

 
Hello guys
My server crashed  but luckily  I was not able to get back my files with help of recovery software.
Now, all I have from the database are just sql server database primary data .mdf and sql server databaseTransaction Log Files .ldf. I need to restore  these data back to sql server.

Please could someone tell me how to restore these two file types back to my sql sever 2007 database?
Thanks
netboy
 
 

View 3 Replies View Related

How To Backup CE Database Tables And Restore To Newer Database?

Jul 3, 2007

I am fairly new to VS 2005 and SQL Server CE. I have developed a Desktop Windows application using VB 2005 and the SQL Compact Edition Database. This application will sell to users via web download.

When they download a service patch, or updated version, I wish for them to retain the data in their present database. In other words, fill the new database with the old data. The new table structures will remain intact except for added columns at the end.

Question is how to save the old data and update the new database with it. Is there an easy way to do this, or do I need to write a module to save a database copy, and update the new database with content at install time?

View 6 Replies View Related

Mirroring :: Principal Database Get Role Back After Being Back On Line

May 14, 2015

New to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.

When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on the roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?

View 2 Replies View Related

SQL 2012 :: Tables Removed From Diagram After Database Restore

Jun 9, 2015

In last week my database was crashed and some how i managed to restore it back on SQL2K12 but after restoration all the relationships are removed and sql server is showing below message when i open diagram of the database.Table(s) were removed from the diagram because privileges were removed to these table(s) or the table(s) were dropped.how to get back all the relationships of the tables.

View 2 Replies View Related

Back And Restore MSSQL

Mar 14, 2008

How could i back and restore my MSSQL using a programmatic way throw asp.net. Also Can i use do an incremental back. Regards,IseL 

View 7 Replies View Related

Back Up And Restore Problem

Aug 11, 2006

Hi All,

I have a problem that I haven't been able to solve it. At the end I am confused I need some clarifications.

Background:
I am using full back up recovery plan. I am getting daily full back up and every 15 minutes log_back up. I created these back ups by using Database Maintenance option. However I have been trying to restore the log_back up, but I couldn't achieve it.

Question1- When I take log back up do I have to activate "Remove inactive entries from transaction log" or not??

Info: When the log back up was done it deletes the latest 4th one. I have done this without no reason. Should I keep like that or should I allow the files being deleted right away after transaction logs backed up?

Question2- I cannot restore the log files I don't know why? I have followed every description that I read. After I restored full back up with NOREOCVERY the database hangs out says "loading" but it doesn't do anything and when I try to restore it doesn't accept the latest log back up file and it urges me to put newer file than I have but ıt is only latest log back up that I have Why does this happen?

I am so confused. Please help me
:confused:

Thanks

LS

View 3 Replies View Related

SQL Diagrams And Back And Restore

Jan 25, 2006

Everyone,
I simply would like to know if ER Diagrams (under Database -Diagrams) on SQL Server and removed once the database is updated via a backup and restore.
Thanks,
Saurav

View 1 Replies View Related

Back And Restore Scripting

May 23, 2008



Hi i am backing up a database, copying it to a shared folder on a different computer on same LAN, then restoring it on the different computer.
it used to work fine untill last few weeks.
I have also tried robocopy to copy the files....doesnt works.
the backup is 90GB.
It reports, insufficient resources.
I have rebooted the different computer too.

View 1 Replies View Related

Restore Back To SQL 2000

Oct 1, 2007

Is it possible to uninstall SQL 2005 and reinstall SQL 2000 if I need to? I would obviously have a backup copy of the database(s) from the SQL 2000 version. If so, is this a major ordeal to perform?

View 5 Replies View Related

Back Up And Restore For Hosting Company

Jan 16, 2008

Hi I need for my hosting company to send my db that I have convert from SQL EXR.2005 to 2000 and send them a backup file.
 I have back up it (task> backup )and sand it over they cant open (restore) it and I do not understand why
 What did I do wrong? (this time:- )
Thanks assaf

View 1 Replies View Related

Back Up To A Logical Device And Restore It

Nov 6, 2007

I want to back up my database to a logical drive and restore it from this logical device. But I am unable to see my logical device through sql server management studio interface. I am able to back up to a logical device and restore it from logical device through T-SQL code. I am wondering how come I am unable to see my logical device from sql server management studio interface. Is there any way, I can solve this problem? Thanks in advance.

View 3 Replies View Related

Back Up And Restore Using Transaction Log And Incremental Backup

Feb 1, 2001

hi, I would like to know the correct reaction for a crash in both senarios.
First senario,
I made a full back up at 6 am , then scheduled sql server to make transaction log back up every 2 hours (8,10,12,2 pm,4,6,8) . If I have a crash at 12:30. How would I resotre the data in the first senario....Can I restore the full back up done at 6 am then restore the last transaction log backup ( which is 12 Noon ) . I am not sure If I need to resotre the whole tran from 6 am till the time it was crashed.

Second senario,

I made a full back up at 6 am, then scheduled sql server to make Incremental backup every 2 hours (8,10,12,2 pm,4,6,8) . If I have a crash at 3:00 pm. How would I resotre the data in the second senario. ....Do I restore the full backup at 6 am then restore each incremental backup backwords ( 2,12,10,8)

AS you can see, I am not sure how to deal with this issue, I do appreciate your feedback.

Best regards

Ahmed

View 1 Replies View Related

Upgrading Hard Drives, Best Way To Back Up And Restore SQL

Jul 20, 2005

I'm formatting my mirrored drives and installing a third drive forraid 5 to add more space. I have backup exec. Can anyone tell me thebest way to backup SQL so I can be sure it will restore properly? Iwas thinking of using imaging software and creating an image to a USB2.0 hard drive. The DB is 80 gigs.ThanksNH

View 3 Replies View Related

How To Verify The Integrity Of A Back-up File Prior To Restore?

Mar 22, 2007

Hello,

I have some C# (.NET 2.0) code that performs back-ups and also can perform restores of back-up files. I would like to validate the integrity of a file prior to initiating a restore operation. In other words, I want to know, before I try to restore, if the file is just a random file (picture, work doc, zipped backup, etc.) or if it is a valid SQL backup file.

Any help would be greatly appreciated.

Thanks,

hassiah

View 3 Replies View Related

Back && Restore From Network Path Using SQL Server 2005 Express Edition

May 27, 2008



I am trying to restore database from network drive but
sql server 2005 express is giving error
"system.data.sqlclient.sqlErroratabase <dbname> cannot be opened due to inaccessible files
or insufficient memory or disk space (microsoft.sqlserver.express.smo)."
But when I restore database from "C:" or local drive it alows to do so.
Can anyone help.



View 5 Replies View Related

Tables Not Being Written Back To DB From Dataset. I'm Going Nutz!

Sep 26, 2006

ok. the problem: some tables are empty, so i can't be sure why some are updating at the DB and some arent.
I have manually picked thru every line of the xml that i'm reading into the dataset here, and it is fine, data is all valid and everything.
the tables i'm most worried about are bulletins and surveys, but they all have to be imported from my upload, the code steps thru just fine and I've been thru it a million times. Did I miss something in my dataadapter configuration?. 'daBulletin        '        Me.daBulletin.ContinueUpdateOnError = True        Me.daBulletin.DeleteCommand = Me.SqlDeleteCommand17        Me.daBulletin.InsertCommand = Me.SqlInsertCommand17        Me.daBulletin.SelectCommand = Me.SqlSelectCommand25        Me.daBulletin.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "tblBulletin", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("BulletinID", "BulletinID"), New System.Data.Common.DataColumnMapping("ContractID", "ContractID"), New System.Data.Common.DataColumnMapping("Msg_Type", "Msg_Type"), New System.Data.Common.DataColumnMapping("DatePosted", "DatePosted"), New System.Data.Common.DataColumnMapping("Subject", "Subject"), New System.Data.Common.DataColumnMapping("B_Body", "B_Body"), New System.Data.Common.DataColumnMapping("I_Read_It", "I_Read_It"), New System.Data.Common.DataColumnMapping("DateRead", "DateRead")})})        Me.daBulletin.UpdateCommand = Me.SqlUpdateCommand16
  here is my merge function: Private Function Merge(ByVal sFilename As String, ByVal User As String) As String
        Dim connMerge As New SqlConnection(ConnectionString)
        Dim dsNew As New dsBeetleTracks
        Dim dsExisting As New dsBeetleTracks
        Dim strResult As String
        SetConnections(connMerge)
        Dim idc As New System.Security.Principal.GenericIdentity(User)
        Dim currentUser As BeetleUser = bu

        dsNew.ReadXml(sFilename)

        If currentUser.IsInRole("Admin") Or currentUser.IsInRole("QA") Then
            If dsNew.tblBulletin.Count > 0 Then
                daBulletin.Fill(dsExisting.tblBulletin)
                dsExisting.Merge(dsNew.tblBulletin)
                strResult += daHelipads.Update(dsExisting.tblBulletin).ToString + " Bulletins updated<br>"
            End If
        End If

        If dsNew.tblHours.Count > 0 And (currentUser.IsInRole("Survey") Or currentUser.IsInRole("Admin")) Then
            daHours.Fill(dsExisting.tblHours)
            dsExisting.Merge(dsNew.tblHours)

            strResult += daHours.Update(dsExisting.tblHours).ToString + " hours updated<br>"
        End If

        If dsNew.tblHeliPads.Count > 0 Then
            daHelipads.Fill(dsExisting.tblHeliPads)
            dsExisting.Merge(dsNew.tblHeliPads)
            strResult += daHelipads.Update(dsExisting.tblHeliPads).ToString & " helipads updated "
        End If

        If dsNew.tblExpenses.Count > 0 Then
            daExpenses.Fill(dsExisting.tblExpenses)
            dsExisting.Merge(dsNew.tblExpenses)

            strResult += daExpenses.Update(dsExisting.tblExpenses).ToString + " expenses updated<br>"
        End If

        If dsNew.tblPersons.Count > 0 And (currentUser.IsInRole("Survey") Or currentUser.IsInRole("FB") Or currentUser.IsInRole("Heli-burn")) Then
            daPersons.Fill(dsExisting.tblPersons)
            dsExisting.Merge(dsNew.tblPersons)
            strResult += daPersons.Update(dsExisting.tblPersons).ToString + " persons updated<br>"
        End If

        If currentUser.IsInRole("Field") Then
            daSurveys.SelectCommand.CommandText = "exec Surveys_Field_Select"
            daSurveys.InsertCommand.CommandText = "exec Surveys_Field_Insert"
            daSurveys.UpdateCommand.CommandText = "exec Surveys_Field_Update"
        End If

        If dsNew.tblSurveys.Count > 0 And (currentUser.IsInRole("Survey") Or currentUser.IsInRole("Field")) Then ' Or CurrentUser.IsInRole("Admin")) Then

            daSurveys.Fill(dsExisting.tblSurveys)
            dsExisting.Merge(dsNew.tblSurveys)

            strResult += daSurveys.Update(dsExisting.tblSurveys).ToString + " surveys updated<br>"
        End If

        If dsNew.tblSurveyChecks.Count > 0 And (currentUser.IsInRole("QA") Or currentUser.IsInRole("Admin")) Then
            daSurveyChecks.Fill(dsExisting.tblSurveyChecks)
            dsExisting.Merge(dsNew.tblSurveyChecks)

            strResult += daSurveyChecks.Update(dsExisting.tblSurveyChecks).ToString + " survey checks updated<br>"
        End If

        If dsNew.tblTreatments.Count > 0 And (currentUser.IsInRole("FB") Or currentUser.IsInRole("Heli-burn")) Then ' Or CurrentUser.IsInRole("Admin")) Then
            daTreatments.Fill(dsExisting.tblTreatments)
            dsExisting.Merge(dsNew.tblTreatments)

            strResult += daTreatments.Update(dsExisting.tblTreatments).ToString + " treatments updated<br>"
        End If

        If dsNew.tblInternalQC.Count > 0 And (currentUser.IsInRole("FB") Or currentUser.IsInRole("Heli-burn") Or currentUser.IsInRole("Survey")) Then ' Or CurrentUser.IsInRole("Admin")) Then
            daInternalQC.Fill(dsExisting.tblInternalQC)
            dsExisting.Merge(dsNew.tblInternalQC)

            strResult += daInternalQC.Update(dsExisting.tblInternalQC).ToString + " internalqc updated<br>"
        End If

        If dsNew.tblTreatmentChecks.Count > 0 And (currentUser.IsInRole("QA") Or currentUser.IsInRole("Admin")) Then
            Try
                daTreatmentChecks.Fill(dsExisting.tblTreatmentChecks)
                dsExisting.Merge(dsNew.tblTreatmentChecks)
                strResult += daTreatmentChecks.Update(dsExisting.tblTreatmentChecks).ToString + " treatment checks updated<br>"
            Catch dbex As DBConcurrencyException
                strResult += vbCrLf & dbex.Message
                For x As Integer = 0 To dbex.Row.Table.Columns.Count - 1
                    strResult += vbCrLf & dbex.Row.GetColumnError(x)
                Next
            End Try
        End If

        If dsNew.tblHeliPiles.Count > 0 And (currentUser.IsInRole("Heli-burn")) Then ' Or CurrentUser.IsInRole("Planner")CurrentUser.IsInRole("QA") Or CurrentUser.IsInRole("Admin") Or
            daHeliPiles.Fill(dsExisting.tblHeliPiles)
            dsExisting.Merge(dsNew.tblHeliPiles)

            strResult += daHeliPiles.Update(dsExisting.tblHeliPiles).ToString + " piles updated<br>"
        End If

        If dsNew.tblHeliCycles.Count > 0 And (currentUser.IsInRole("Heli-burn")) Then ' CurrentUser.IsInRole("Planner") Or Or CurrentUser.IsInRole("Admin")) Then
            daHeliCycles.Fill(dsExisting.tblHeliCycles)
            dsExisting.Merge(dsNew.tblHeliCycles)

            strResult += daHeliCycles.Update(dsExisting.tblHeliCycles).ToString + " cycles updated<br>"
        End If

        If dsNew.tblHeliTurns.Count > 0 And (currentUser.IsInRole("Heli-burn")) Then 'CurrentUser.IsInRole("Admin") Or CurrentUser.IsInRole("Planner") Or
            daHeliTurns.Fill(dsExisting.tblHeliTurns)
            dsExisting.Merge(dsNew.tblHeliTurns)

            strResult += daHeliTurns.Update(dsExisting.tblHeliTurns).ToString + " turns updated<br>"
        End If

        If dsExisting.HasChanges Then
            dsExisting.Merge(dsNew)
        End If
        dsExisting.AcceptChanges()


        'duh.
        'If dsNew.HasChanges Then
        '    dsNew.AcceptChanges()
        'End If
        If dsExisting.HasErrors Then
            Dim bolError As Boolean
            Dim tempDataTable As DataTable
            bolError = True

            strResult += "<br>"

            For Each tempDataTable In dsExisting.Tables
                If (tempDataTable.HasErrors) Then
                    strResult += PrintRowErrs(tempDataTable)
                End If
            Next
        End If

        dsNew.Dispose()
        dsExisting.Dispose()
        connMerge.Close()
        'edebugging will only track strresult
        Dim fsError As New FileStream(Server.MapPath("./incoming/error.txt"), FileMode.Create, FileAccess.Write)
        Dim swError As New StreamWriter(fsError)
        swError.WriteLine("--==ERROR LOG==--")
        swError.WriteLine(Now.Date.ToShortDateString)
        swError.WriteLine("-----------------")
        swError.WriteLine(strResult)
        swError.Close()
        fsError.Close()

        Return strResult
    End Function

View 2 Replies View Related

SQL 2012 :: Join Tables And Only Pull Back Certain Values?

Oct 22, 2014

I am having problems joining these two tables and returning the correct values. The issue is that i have a work order table and a revenue table. I only want to return the sum of the revenue when the revenue comes after the work order date. That is simple enough, but it gets tricky when there are multiple work orders for the same ID. for those instances, we only want the sum of the revenue if it shows up post the work order date and if it is before any other work order date. So ID 312187014 should only have the 9-5 revenue from below, not the 7/7 or 8/6 revenue because the 8/7 work order date is after those revenue dates and thus will not have any revenue tied to it because there is a 9/3 work order that ties to the 9/5 revenue. Additionally the 412100368 ID has a 7/7 work order that ties to the 7/26 revenue, and the 8/7 work order will tie to the 8/23 and 9/20 revenue

--===== Create the test table with

CREATE TABLE #workorder
(
Id varchar(20),
wo varchar(10),
wodate datetime,
amount float
)
GO
CREATE TABLE #revenue

[code].....

View 2 Replies View Related

Pulling Data Back From 2 Tables - Join On Top 1 Record

Nov 7, 2013

I have sql pulling back data from 2 tables (Ticket, Assignment) matching on an ID.

however the Assignment table can have more than 1 record for a matching ID in the Ticket table so is bringing back rows for each of these entries HOWEVER i only want 1 row returned matching on the FIRST record in Assignment table (on earliest DateAssigned field)

Here's my code

SELECT t.TicketID, CreatedByUserID, CreatedForUserID, DateCreated, a.DateAssigned FROM Ticket t
INNER JOIN Assignment a ON (SELECT TOP 1 TicketID FROM Assignment
WHERE [TicketID] = t.TicketID
ORDER BY DateAssigned ASC) = t.TicketID

WHERE (CreatedByUserID NOT IN (SELECT u.UserID FROM Users u
INNER JOIN Profiles p ON u.UserID = p.UserID

[Code] ....

View 4 Replies View Related

T-SQL (SS2K8) :: Union Of Two Tables Returned Back To Main Query

Aug 18, 2014

Currently I have a standard query with a join to several tables. There are two additional tables MAS_CTB and MAS_STB. I would like to do a union between those two tables to get FIELDVALUE which will exist in either the CTB table or the STB table and then have that value be returned with the results of the original query.

I can of course write a UNION from the main query to the CTB and then to the STB table, however it's about 80 dummy fields I would have to replicate in the union which is why I was wondering if there was a more simple way.

Main Query:
SELECT Field1, Field2...Field80
From Table1
Join Table2

Union Portion:
Select FieldValue <------
From MAS_CTB
UNION
Select FieldValue <-----Return to main query above
From MAS_STB

View 3 Replies View Related

How To Bring Back The Distinct Values In Single Column From Two Tables

Jul 20, 2005

12.) Now you have two different tables - each with two columns.Table #1Single Column2 rows with a value equal to 1 and 2Table #2Single column2 rows with a value equal to 2 and 4Construct a statement returning in a single column all the valuescontained, but not the common values.This is another question that I got in an interview, I missedit.......Thanks,Tim

View 1 Replies View Related

Database Restore Failed, Now Inaccessible And Can Not Restore.

Apr 27, 2007

I have seen this before. A 2000 restore fails, leaving the database thinking it is being restored but the restore job failed and errors when it is restarted. EM is clueless. I believe there is a proc to reset some flag. Can you share it with me???



Thanks!

View 4 Replies View Related

The Log File For Database 'Home_alone' Is Full. Back Up The Transaction Log For The Database To Free Up Some Log Space.

Feb 4, 2008



Hi all

Iam working in Prodcution ENV,Please help how make space


The log file for database 'Home_alone' is full. Back up the transaction log for the database to free up some log space.

View 10 Replies View Related

Correct Syntax To Pull Back Duplicate Vendors Based On 6 Fields From Two Different Tables

Feb 20, 2015

I'm looking for the correct syntax to pull back duplicate vendors based on 6 fields from two different tables. I want to actually see the duplicate vendor information (not just a count). I am able to pull this for one of the tables, something like below:

select *
from VendTable1 a
join ( select firstname, lastname
from VendTable1
group by firstname, lastname
having count(*) > 1 ) b
on a.firstname = b.firstname
and a.lastname = b.lastname

I'm running into issues when trying to add the other table with the 4 other fields.

View 5 Replies View Related

Updating A Production Database With Back Up Of Development Database

May 11, 2007

Can someone provide a step by step tutorial for this? I'd like to safely update a database that is used for a website without much or any downtime.

View 1 Replies View Related

New Database Not Included In Back Up Database Task

Aug 10, 2007

I'm having a problem with a Maintenance Plan created for SQL Server 2005 using Microsoft SQL Server Management Studio. See version information at the bottom of this post.

I have a Maintenance Plan using the "Back Up Database Task" that is set to perform a "Full" back up of "All Databases" on the local server. However, it appears that the list of "All databases" are hard-coded to be those databases that were available at the time the task was created. It seems any newly created databases don't appear to be in the list. If I attempt to edit the task and select the "These databases:" option, the newly created databases aren't even in the list.

Is there some way to have the task refresh the list of the databases available for backup? Ideally, I'd like any newly created databases to get backed up automatically without having to modify the task.

Thanks for your help,

Jonathan.


Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

View 6 Replies View Related

RESTORE Database - Database In Use, Restore Fails

Nov 19, 1999

11/19

Trying to keep out sysadmins & sa during/between database RESTORE

Configuration:
WINNT Server Enterprise 4.0 w/SP5
SQL Server 7 Enterprise & SP1

2 SQL Servers:
Production Server
Standby server

I Backup (full backup) databases to disk on primary server (logical backup devices are physicaly located on a Standby server (dedicated gigabit NIC in each server for this process). Transaction logs are applied to the Standby server throughout the day.

Problem:
How to keep out "sa" and sysadmins from a database while I'm restoring (or between restores) to a standby server?
The database being restored cannot be in use during a restore.
If a DBA forgets that this process is happening, the statement fails (RESTORE)for the database they happen to be in at the time of the restore.

Example restore statement:
Standby Server -
RESTORE DATABASE databasename FROM database_dd WITH DBO_ONLY, REPLACE, STANDBY = 'g:Mssql7FromPrimaryDatabaseName_undo.ldf'

I could restrict Domain sysadmin access and change sa password. I could also put the database in "Single user" mode, however this could become problem if my process disconnects and then someone else connects - then my process is locked out. What I'm really looking for is to lock out all activity for a database that is in "standby mode" except for RESTORE processes.

Any ideas??

Wade
wadej@vailresorts.com

View 1 Replies View Related

Database Back Up

Mar 27, 2008

Can any body help with sample code to backup (sql server 2005 express)database using VB.net on click of a button?
Thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved