I am trying to backup a database which is on the server and restore it on my
local server. Can anyone please tell me how to do this? Thanks in advance.Have a look at HOW TO: Move Databases Between Computers That Are Running SQL
Server
http://support.microsoft.com/defaul...kb;en-us;314546
"PH" wrote:
> I am trying to backup a database which is on the server and restore it on
my
> local server. Can anyone please tell me how to do this? Thanks in advance.|||From Enterprise Manager, right click the DB for which you want to take backu
p,
Select all tasks ->, Backup database …follow the wizard to store backup
Restoring…
Create a new database with the same name as backedup db right click select
all tasks->restore database… follow the wizard to restore.
Thanks,
RK
"PH" wrote:
> I am trying to backup a database which is on the server and restore it on
my
> local server. Can anyone please tell me how to do this? Thanks in advance.|||Thanks a lot! That worked.
"Ana Mihalj" wrote:
> Have a look at HOW TO: Move Databases Between Computers That Are Running S
QL
> Server
> http://support.microsoft.com/defaul...kb;en-us;314546
>
> "PH" wrote:
>|||you can use sql command in Query Analyser on the source server:
Backup Database dbName to disk = 'c:\dbBackup'
you copy the file created on the hard disk and put it on the local disk on
destination server and you run the command
Restore Database dbName from disk = 'c:\dbBackup'
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:1ADA0DFC-2F8F-4CF9-B834-BEBAC3139D9C@.microsoft.com...
> Have a look at HOW TO: Move Databases Between Computers That Are Running
> SQL
> Server
> http://support.microsoft.com/defaul...kb;en-us;314546
>
> "PH" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment