July 10, 2008 at 12:57 pm
Hi All,
I am a junior DBA, and I have to perform the following:
An application server is going to be installed in a new server, from which we have to create a new Database pointing to this application....this is ok....now, I have other Server now running with the database that was working with this application, now it is down. I don't want to delete this "old" database, I want to archive this, so in the future I can use it for get reports.....so, how can I move the data into some other Source (as a flat file) in order to keep it and use it for make reports.
Please any suggestion???....How can I do it, any step by step doc, please?
OS: Windows server 2003
SQL Server : 2000
Please I need help..any idea how can I perform this??? :crying:
Thanks.
July 10, 2008 at 1:18 pm
why not keep it as a database, change its name and make it read only as it will only be used for reporting. Move it to the new server using backup\restore or detach\attach
---------------------------------------------------------------------
July 10, 2008 at 1:22 pm
Thank you, you are very kind in giving me some help....would you mind suggest me some docs in which I can follow step by step this job? I had a little experience doing this working with Oracle DB's and it was a disaster, I lost my CTL, and LOG files..I don't want this happend to me again.
Thanks.
July 10, 2008 at 1:31 pm
forget that silly overcomplicated RDBMS, Oracle, SQL server much easier.
see this article:
http://support.microsoft.com/kb/314546
also read up on sp_help_revlogin
to set a database read only - alter database dbname set read_only
---------------------------------------------------------------------
July 10, 2008 at 1:39 pm
Thanks a lot..
I will start working on it now, and if something happend I will let you know.
Thank you again.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply