Hi,
I have got a sql server installation folder.. (data and log files
folder). The server crashed so installed a new OS and sql server
instance. I have recovered the old drive with the data and other
folders.
I tried copying all the files to the new data folder while the server
is not running and tried to start the server hoping that all my
databases and sql agent task will be there. But needless to say the sql
server wouldn't start like that. So i replaced the files back with the
newly installed files.
Now I have got these data folders with all my databases. I have copied
the mdf and ldf files and attached it to the newly installed server and
I have got back my databases. Is there a way to recover all the sql
agent tasks I used to have? How can I restore my msdb or master
databases..
Any tips would be appreciated..
Thanks
Sazzad> I have got back my databases. Is there a way to recover all the sql
> agent tasks I used to have? How can I restore my msdb or master
> databases..
Did you back up them?
"Sumon" <sumon.net@.gmail.com> wrote in message
news:1160981526.080016.173980@.h48g2000cwc.googlegroups.com...
> Hi,
> I have got a sql server installation folder.. (data and log files
> folder). The server crashed so installed a new OS and sql server
> instance. I have recovered the old drive with the data and other
> folders.
> I tried copying all the files to the new data folder while the server
> is not running and tried to start the server hoping that all my
> databases and sql agent task will be there. But needless to say the sql
> server wouldn't start like that. So i replaced the files back with the
> newly installed files.
> Now I have got these data folders with all my databases. I have copied
> the mdf and ldf files and attached it to the newly installed server and
> I have got back my databases. Is there a way to recover all the sql
> agent tasks I used to have? How can I restore my msdb or master
> databases..
> Any tips would be appreciated..
> Thanks
> Sazzad
>|||Uri Dimant wrote:
[vbcol=seagreen]
> Did you back up them?
>
> "Sumon" <sumon.net@.gmail.com> wrote in message
> news:1160981526.080016.173980@.h48g2000cwc.googlegroups.com...
If you have backup of MSDB you can restore its backup or if you have
mdf/ldf files you can attach files.
Which version of SQL Server you are using? 2000 or 2005?
Regards
Amish shah
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment