.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

Backup a database then stop it

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
 

Hi,

In my SQL Server 2000, I have a particular database that I would like to stop it immediately after I backup that database.  What I would like to do is to restore that backup file to a new SQL Server 2008 machine, so the application used to connect to the SQL Server 2000 db can connect to the SQL Server 2008 db.  The connection for the application connected to the SQL Server 2000 db is using the IP method(e.g., 192.168.X.X).
How do I do the backup then stop that database job in SQL Server 2000?
Thanks for help.

Jason




View Complete Post


More Related Resource Links

Backup a database then stop it

  

Hi,

In my SQL Server 2000, I have a particular database that I would like to stop it immediately after I backup that database.  What I would like to do is to restore that backup file to a new SQL Server 2008 machine, so the application used to connect to the SQL Server 2000 db can connect to the SQL Server 2008 db.  The connection for the application connected to the SQL Server 2000 db is using the IP method(e.g., 192.168.X.X).
How do I do the backup then stop that database job in SQL Server 2000?
Thanks for help.

Jason


How to stop the repeated database queries for roles

  

Hello, friends,

We have a web application using VS 2008, c#. We try to filter siteMap nodes based on security roles. We have our customized the mether GetRolesForUser() in RoleProvider class to determine a user's role. In this method, roles will be returned by querying an SQL Server database.

However, we found that each time a page was loaded/refershed, this  GetRolesForUser() was called, and the database would be queried. This is too MUCH and expensive.

We thought the roles should be queried only once when a user logs in. After that, role info should be stored somewhere for this user, rather than query DB all the time.

Any ideas, reference paper, snipet,...,?

Thanks a lot!


SQL2008 - Cannot Restore a new database from a full backup of a different one, database in use

  
I am trying to restore a brand new database from a copy of another one and am encountering an error message stating: System.Data.SqlClient.SqlError: The file <Backup source database file location> cannot be overwritten.  It is being used by database <Backup Source Database>. (Microsoft.SqlServer.Smo) I am running the Restore procedure with the REPLACE option and am wondering why it is stating that the source database is the database in use when I am trying to restore and overwrite a completely different database. This issue happens when running the replace both in C# using SMO and when manually restoring with SqlServer Management Studio Interesting note is, the original source database is created / deployed using a database project within VisualStudios 2010 and then deployed to SqlServer through VisualStudios. Any thoughts on why this is happening? Thanks in advance for any help!

Can't restore database backup file in my database ? using sql server 2005. please help

  
VERY IMPORTANT i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server) i am trying to restore back up database .bak into the new database i just created in sql server 2005 i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message "You must select a restore source" Here's the screen shot:   PLEASE HELP..it's really important (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)  

How to Include Password during Database Backup over Tape

  
Hi All, We have EMC Backup Solution in our organization which does backup of all the databases. I want to know is there any way that i can include the password option whenever Backup runs. I dont want to modify any script at the EMS Backup solution side. I want to do it on the fly.         Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

Is there a way to backup all my store procedures under a particular SQL 2005 database?

  
hi all, Is there a script, doc, VBS script, SQL statement out there which will read all my store procedures and save them as a TXT file? Currently I have to save all of them in text files before I update them when I get a new web site release. Thank you  JCD

how to restore msdb database on sql 2008 from sql 2005 backup?

  
Currently, I am unable to do it. It gives me the error than I cannot be restored because it was created by a different version of the server. What is the work-around? I hate scripting all my maintenance plans and alerts, there are tonns of themJulieShop

"The backup set holds a backup of a database other than existing database. Restore Database is term

  
I have a problem when i restore my .DAT_BAK file.  I am getting error like "The backup set holds a backup of a database other than existing database.  Restore Database is terminating abnormally".   I tried by using   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH MOVE 'VZAI_DATA' TO D:\PROGRAM FILES\..\MSSQL\TEST.MDF', MOVE 'VZAI_LOG' TO D:\PROGRAM FILES\..\MSSQL\TEST.LDF', REPLACE   And also i tried like   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH REPLACE   When i use like this,   RESTORE FILELISTONLY FROM DISK = 'D:\DATA\MYTEST.DAT_BAK'. I am able to get the output as LogicalName, PhysicalName, Type, FileGroupName, Size, etc.   Can i anyone please help me out?   Thanks in Advance, Anand Rajagopal

calculating the size required for backup of database

  
Hi, How to calculate the size required to take backup of a database in mssql 2000.the results returned by sp_spaceused differ too much from the actual size taken on the disk. Thanks in advance

: Exclusive access could not be obtained because the database is in use.could not applu log backup f

  
I have 50 databases all are log shippipped.i am getting below error for some databases some time 2010-09-07 15:45:21.04 *** Error: Could not apply log backup file '\\ds\M$\CT_20100907190004.trn' to secondary database 'dsCT'.(Microsoft.SqlServer.Management.LogShipping) *** 2010-09-07 15:45:21.04 *** Error: Exclusive access could not be obtained because the database is in use. I have selected option to disconnect all users when database is in restoring state also. Backup is schedule to run at every hour suppose 12 copy will run at 12:15 and restore will run a 12:45pm. Urgent because i am getting this error on all servers  

Full database backup takes so long

  
Today several full database backups took so long. Normally it took 2 hours to backup. But today the 5 backups didn't finish by the end of the work day. The backups went well until yesterday. I don't know what happened overnight. Is there a performance tool embedded in SQL Server? How can I find out why the backups take so long? What could be the possible reasons? Thank you,  

Backup Database

  
Is there a way to execute Backup Database ONLY on the condition that nothing has been updated inserted or deleted? Thanks  

Full Farm Backup Fails on Windows Sharepoint Services Search Database

  
I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

MSSQL 2008 R2 - database in restoring mode after backup - forever..

  
Hi folks,   i have this problem that occourred today with one instance of MSSQL 2008 R2 running on a WIN x64 R2 enterprise server.   i have run a backup maintainance job and now i have two databases in restoring mode for over 4hrs.   my questions are: why are these databases restoring when i was backing up? and why are they not being logged anywhere - i can not find anything on logs, activty monitor, or even Windows Resource Monitor.   i can not see any work been done by MSSQL to restore these databases, and yet they are set as 'RESTORING'.   any suggestion from the community here will be much appreciated as i am banging my head against the wall already.   thanks,   Nicolas    data warehouse | data migration | ETL/ELT | UK | http://www.brainpowered.net

SharePoint 3.0 stop logging after moving database

  
Hello! Our SP 3.0 logging and Usage Analysis Processing were used to working ok. After we moved database to another server for disk space reason, there is no new log file generated from the date of db moving. The logging settings and Usage Analysis setting are still the same. We tried disable / re-enable logging, it didn't help. From system log, I saw following errors, and then granted the service account all access to "IIS WAMREG admin Service" DCOM Config based on document found in MSDN. It still not help "The application-specific permission settings do not grant Local Activation permission for the COM Server application ..." Could someone please share info/knowledge on similar issue and solutions? I really appreciate it! Thank you in advance! John

need information on database backup

  
Hi, As a developer Ihave very minimal knowledge on database backups. Before reaching out to DBA I want to understand few things 1) I need to place a request to create new database on a SQL Server. There is around 540 GB space on this server but the two existing databases on this server already used 500GB space. So what option do we have to create new database? Is it a simple task to add another drive and allocate some space or use mapped drive? what options can I suggest DBA? 2) Also DBA mentioned that there is no space to take backup on this drive for the existsing database. What option can I suggest for backup incase if we plan to drop one of the database which is not actively used?

database backup

  
Hi, i have a problem with database backup. i want to backup database which is in another domain to my local  system. please solve this problem ASAP thanks in advance
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend