Click here to Skip to main content
15,867,686 members
Home / Discussions / Database
   

Database

 
AnswerRe: e-blood bank [modified] Pin
annathor2-Sep-09 1:42
annathor2-Sep-09 1:42 
GeneralRe: e-blood bank Pin
samawat8-Dec-09 4:49
samawat8-Dec-09 4:49 
GeneralRe: e-blood bank Pin
samawat8-Dec-09 4:51
samawat8-Dec-09 4:51 
AnswerRe: e-blood bank Pin
AlexeiXX33-Sep-09 9:47
AlexeiXX33-Sep-09 9:47 
QuestionExporting a database Pin
MarkB7771-Sep-09 23:09
MarkB7771-Sep-09 23:09 
AnswerRe: Exporting a database Pin
SeMartens2-Sep-09 0:14
SeMartens2-Sep-09 0:14 
AnswerRe: Exporting a database Pin
Jerry Hammond2-Sep-09 2:34
Jerry Hammond2-Sep-09 2:34 
AnswerRe: Exporting a database Pin
Abhishek Sur2-Sep-09 9:53
professionalAbhishek Sur2-Sep-09 9:53 
Just run backup...

Run this script in your office computer :

BACKUP DATABASE [db] TO  DISK = N'c:\Backup\db.bak' WITH NOFORMAT, NOINIT,  NAME = N'db-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO


It will produce an output db.bak in your local C:\backup folder.
[Please replace db with your database name on the script.]

Now in home run this :
RESTORE DATABASE [db] FROM  DISK = N'C:\Backup\DB.bak' WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10
GO


Here db is the name of the database it will create when it restores, place the db.bak file from your office to your home computer in C:\backup or whatever you like to and finally run it..

Cool | :cool: Cool | :cool:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB

Don't forget to click "Good Answer" if you like to.

AnswerRe: Exporting a database Pin
εїзεїзεїз2-Sep-09 11:43
εїзεїзεїз2-Sep-09 11:43 
GeneralRe: Exporting a database Pin
Abhishek Sur2-Sep-09 11:59
professionalAbhishek Sur2-Sep-09 11:59 
GeneralRe: Exporting a database Pin
εїзεїзεїз2-Sep-09 13:42
εїзεїзεїз2-Sep-09 13:42 
QuestionWhat is SQL Query:Master child table [modified] Pin
xodeblack1-Sep-09 20:24
xodeblack1-Sep-09 20:24 
AnswerRe: What is SQL Query:Master child table Pin
Mycroft Holmes1-Sep-09 21:14
professionalMycroft Holmes1-Sep-09 21:14 
GeneralRe: What is SQL Query:Master child table Pin
xodeblack1-Sep-09 22:39
xodeblack1-Sep-09 22:39 
GeneralRe: What is SQL Query:Master child table Pin
Mycroft Holmes1-Sep-09 22:50
professionalMycroft Holmes1-Sep-09 22:50 
AnswerRe: What is SQL Query:Master child table Pin
Nisha Agrawal7-Sep-09 3:57
Nisha Agrawal7-Sep-09 3:57 
Question[Message Deleted] Pin
teja.murali31-Aug-09 19:32
teja.murali31-Aug-09 19:32 
AnswerRe: display cities while clicking country Pin
Mycroft Holmes31-Aug-09 19:45
professionalMycroft Holmes31-Aug-09 19:45 
AnswerRe: display cities while clicking country Pin
Blue_Boy31-Aug-09 23:37
Blue_Boy31-Aug-09 23:37 
QuestionDatabase design and queries Pin
rockyrules31-Aug-09 19:01
rockyrules31-Aug-09 19:01 
AnswerRe: Database design and queries Pin
Mycroft Holmes31-Aug-09 19:26
professionalMycroft Holmes31-Aug-09 19:26 
QuestionGetting the right sysntax for this. Pin
Rudyvb0831-Aug-09 11:00
Rudyvb0831-Aug-09 11:00 
AnswerRe: Getting the right sysntax for this. Pin
Edbert P31-Aug-09 16:48
Edbert P31-Aug-09 16:48 
AnswerRe: Getting the right sysntax for this. Pin
Mycroft Holmes31-Aug-09 19:23
professionalMycroft Holmes31-Aug-09 19:23 
QuestionSSRS Visibility Option Pin
bwood202031-Aug-09 7:09
bwood202031-Aug-09 7:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.