Converting problem: active

Showing posts with label active. Show all posts

Tuesday, March 20, 2012

Copy Database Wizard

Using SQL 2000 SP3a on Windows 2000 Server, Active Directory domain. I want
to copy a database from a development server to a production server. But
when I run the Copy Database Wizard, it says the SQL server Service can't
run under the local system account. I've searched MSDN and couldn't find
anything on this subject. Do I need to enable the Interact with the Desktop
option? Or do I need to create a Domain User for both servers to run under?
Or local users on each machine with some extra priveleges?Have a look at the "Permissions to Copy the Files" section in
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
news:e8hQmUurDHA.3748@.TK2MSFTNGP11.phx.gbl...
Using SQL 2000 SP3a on Windows 2000 Server, Active Directory domain. I want
to copy a database from a development server to a production server. But
when I run the Copy Database Wizard, it says the SQL server Service can't
run under the local system account. I've searched MSDN and couldn't find
anything on this subject. Do I need to enable the Interact with the Desktop
option? Or do I need to create a Domain User for both servers to run under?
Or local users on each machine with some extra priveleges?

Wednesday, March 7, 2012

Copy Active DB to a TEST DB on same machine

I need to copy a active DB to a test db on the same machine. Can someone tell
me how to do this.
ThanksDo a backup (BACKUP DATABASE) of the database, then do a RESTORE DATABASE with a new database name
and use the MOVE option of the RESTORE command to specify new physical database file names.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stup88" <Stup88@.discussions.microsoft.com> wrote in message
news:51E2B75B-3558-4DED-84AF-1FDEE95C703E@.microsoft.com...
>I need to copy a active DB to a test db on the same machine. Can someone tell
> me how to do this.
> Thanks|||Does the database I am backing up need to be offline or can I do that live
with people accessing it ?
"Tibor Karaszi" wrote:
> Do a backup (BACKUP DATABASE) of the database, then do a RESTORE DATABASE with a new database name
> and use the MOVE option of the RESTORE command to specify new physical database file names.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
> news:51E2B75B-3558-4DED-84AF-1FDEE95C703E@.microsoft.com...
> >I need to copy a active DB to a test db on the same machine. Can someone tell
> > me how to do this.
> >
> > Thanks
>|||You can do it live, no problems (it will use some machine resources, of course, but not lock any
data or so).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stup88" <Stup88@.discussions.microsoft.com> wrote in message
news:BB4F039D-AF4F-4F01-A53D-0B52F451CF04@.microsoft.com...
> Does the database I am backing up need to be offline or can I do that live
> with people accessing it ?
> "Tibor Karaszi" wrote:
>> Do a backup (BACKUP DATABASE) of the database, then do a RESTORE DATABASE with a new database
>> name
>> and use the MOVE option of the RESTORE command to specify new physical database file names.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
>> news:51E2B75B-3558-4DED-84AF-1FDEE95C703E@.microsoft.com...
>> >I need to copy a active DB to a test db on the same machine. Can someone tell
>> > me how to do this.
>> >
>> > Thanks
>>|||I am about to attempt this.. made the backup via enterprise manager, and
can't do the restore from that because of the move option that is required to
rename the physical db name.. this is something that has to happen correct.
if so can you give me a example of the code
DB name will be PM Database_test
Backuped DB was PM Database_be
Thanks
"Tibor Karaszi" wrote:
> You can do it live, no problems (it will use some machine resources, of course, but not lock any
> data or so).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
> news:BB4F039D-AF4F-4F01-A53D-0B52F451CF04@.microsoft.com...
> > Does the database I am backing up need to be offline or can I do that live
> > with people accessing it ?
> >
> > "Tibor Karaszi" wrote:
> >
> >> Do a backup (BACKUP DATABASE) of the database, then do a RESTORE DATABASE with a new database
> >> name
> >> and use the MOVE option of the RESTORE command to specify new physical database file names.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
> >> news:51E2B75B-3558-4DED-84AF-1FDEE95C703E@.microsoft.com...
> >> >I need to copy a active DB to a test db on the same machine. Can someone tell
> >> > me how to do this.
> >> >
> >> > Thanks
> >>
> >>
>|||Below is an example from Books Online. You need to adjust for the properties of your database, of
course:
RESTORE DATABASE AdventureWorks
FROM AdventureWorksBackups
WITH NORECOVERY,
MOVE 'AdventureWorks_Data' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\NewAdvWorks.mdf',
MOVE 'AdventureWorks_Log'
TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\NewAdvWorks.ldf'
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stup88" <Stup88@.discussions.microsoft.com> wrote in message
news:935208BB-1489-40F4-A220-F5152C3ED683@.microsoft.com...
>I am about to attempt this.. made the backup via enterprise manager, and
> can't do the restore from that because of the move option that is required to
> rename the physical db name.. this is something that has to happen correct.
> if so can you give me a example of the code
> DB name will be PM Database_test
> Backuped DB was PM Database_be
> Thanks
> "Tibor Karaszi" wrote:
>> You can do it live, no problems (it will use some machine resources, of course, but not lock any
>> data or so).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
>> news:BB4F039D-AF4F-4F01-A53D-0B52F451CF04@.microsoft.com...
>> > Does the database I am backing up need to be offline or can I do that live
>> > with people accessing it ?
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> Do a backup (BACKUP DATABASE) of the database, then do a RESTORE DATABASE with a new database
>> >> name
>> >> and use the MOVE option of the RESTORE command to specify new physical database file names.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://sqlblog.com/blogs/tibor_karaszi
>> >>
>> >>
>> >> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
>> >> news:51E2B75B-3558-4DED-84AF-1FDEE95C703E@.microsoft.com...
>> >> >I need to copy a active DB to a test db on the same machine. Can someone tell
>> >> > me how to do this.
>> >> >
>> >> > Thanks
>> >>
>> >>
>>

Tuesday, March 20, 2012

Copy Database Wizard

Wednesday, March 7, 2012

Copy Active DB to a TEST DB on same machine

Copy Active DB to a TEST DB on same machine

Copy Active DB to a TEST DB on same machine

Converting problem

Blog Archive

About Me