Journey to SQL Authority with Pinal Dave

Posted in Author Pinal, SQL, SQL Authority, SQL Backup and Restore, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Tips and Tricks, SQLAuthority Book Review, T SQL, Technology | 10 Comments

10 Responses to “SQL SERVER - Restore Database Without or With Backup - Everything About Restore and Backup”

1. on August 17, 2007 at 4:10 am ashok

   hi pinaldave how are you.

   please i want more information abot Partitioning table in SQL Server 2005 and SERVICE_BROKER

   How to use service_broker in stored procedure……

   if any notes or material please mail me

   Please help me

   
   
2. on January 13, 2008 at 10:43 am deepak kumar

   Hi pinal,
   I want to get all ur interview question. Could I get it in one book. Could u please tell me where to buy these all interview questions books.

   Deepak Kumar

   
   
3. on February 3, 2008 at 10:52 pm Neil Gorin

   I have added tables to the NOTHWIND database. In the past, when I wanted to update NORTHWIND on a new computer to contain the additional tables, I would do the following in SQL Server 2000:

   1)I would go to my development computer, that contains NORTHWIND with the additional files, and perform a backup to the disk file myfirstback using the enterprise manager.

   2) on the new computer I perform a backup to the disk file myfirstbackup.

   3) I overwrite myfirstbackup on the new computer with myfirstbackup from my development computer.

   4) I perform a restore on the new computer. NORTHWIND database then contains the added tables.

   Please assist me in that SQL SERVER 2005 is not permitting me to use the SQL SERVER 2000 back up file named myfirstback to restore. I created the disk file myfirstbackup while in SQL 2005, overwrite the file with the SQL 2000 version of myfirstbackup and then attempt the restore. SQL 2005 does not permit the operation as I did while in SQL 2000.

   Regards,
   drgorin

   
   
4. on February 12, 2008 at 7:09 am Rob

   Hello,

   What would I do to recover a database if a backup had not been made for 3 months (no transaction logs in that time either, only my current _log.ldf file)? Is this out of the question or could my current log hold the info to restore back from 3 months ago? (It says it’s 120 MB).

   Love you blog, I’ve learned a lot.

   Thanks,

   Rob

   
   
5. on February 26, 2008 at 11:44 am pratik

   i want to know how to get back last deleted table in sql server using query

   
   
6. on March 13, 2008 at 11:17 am aliakbar sadeghi

   hi pinaldave ,

   May I Help me for this question :

   when i use this command :

   RESTORE DATABASE Anbartechnical
   FROM DISK = ‘D:\anb1222.bak’
   WITH NORECOVERY

   Sqlserver 2k5 told me :

   RESTORE cannot process database ‘Anbartechnical’
   because it is in use by this session. It is
   recommended that the master database be used
   when performing this operation.

   PLEASE HELP ME !

   
   
7. on May 22, 2008 at 8:59 am joe

   hello
   i do not have any back up and my user delete the data how can i restore data from log file?it is very impportant for me to restore these data.would you please help me?
   thanks for your answer

   
   
8. on July 1, 2008 at 3:05 pm Rajesh

   Hi,

   I want to backup entitre database using C#, can I do that if no than how do I back up using T-SQL.

   Thank You
   Rajesh

   
   
9. on August 5, 2008 at 12:07 pm komal

   how can i restore a differential bakup after a full backup .
   i have full backup and diffential bakup on different backup sets

   
   
10. on August 21, 2008 at 10:48 am Talwasa khairkhwa

    Hello dear Pinal

    i want some information about backup from one computer to another computer
    i hope help me THANK YOU.