I've looked at all the microsoft articles relating to moving a database from
one location to another using the attach/detach commands and I have one
question. Are those commands typed from a command prompt or do I need to run
these from SQL manager?
Hi,
You can execute those commands from
1. Selecting Query Analyzer from SQL Program groups. (issue the user name
and password to login)
Once you go inside the Query analyzer you could execute all TSQL
commands which includes the detach and attach db commands.
2. FROM command prompt execute OSQL
OSQL -Usa -Ppassword -S <SQL Servername> (enter)
This will go to a SQL prompt; there execute those sp_detach_db and
sp_attach_db commands.
Thanks
Hari
SQL Server MVP
"JL Adamson" <JLAdamson@.discussions.microsoft.com> wrote in message
news:8886FE74-93B2-4FD9-997F-25884FA0F953@.microsoft.com...
> I've looked at all the microsoft articles relating to moving a database
> from
> one location to another using the attach/detach commands and I have one
> question. Are those commands typed from a command prompt or do I need to
> run
> these from SQL manager?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment