Before my hard disk failed , I had backup MSSQL7 folder.After I re format it and attached the database [MDF ,LDF ] I lost my stored procedures.Can someone help me or show me how to recover my stored procedures.
Thanks.The SPs are part of the database and should be there if the database is not corrupt.
Maybe they are owned by a different user or mapped to a different login.
Try select * from sysobjects where type = 'P'
and look in syscomments
select text from syscomments where text like '%myspname%'|||Thanks for your fast response , I am so lucky that get back my 150 stored procedures back from my old 500 MB hard disk !!!
Thanks.sql
Showing posts with label folder. Show all posts
Showing posts with label folder. Show all posts
Wednesday, March 21, 2012
Recover SQL Server Data/Agent Tasks from old Data folder
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.googlegr oups.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.googlegr oups.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
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.googlegr oups.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.googlegr oups.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
Recover SQL Server Data/Agent Tasks from old Data folder
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:
> > 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
> >
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
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:
> > 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
> >
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
Recover SQL Server Data/Agent Tasks from old Data folder
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
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
Tuesday, March 20, 2012
Recover lost data
Hello!
Hopefully someone can help me that i have lost my data on my D: drive.
driven shown all folder but in side of the folder there is nothing.
i have lost my Doc, xls, Jpeg etc. all files.
please help me what sould i have to do.
thanks
This forum is specific to disaster recovery in SQL Server databases.
The standard answer is that you need to find your most recent backup and restore from it.
|||Don't worry you will get back your data. Try Stellar Phoenix Windows Data Recovery Software a file and parition recovery utility which recovers the lost data from formatted hard drive or data lost occur due to software malfunction, viruses or even sabotage.Download the demo version of the software from: http://www.stellarinfo.com/partition-recovery.htm Scan your hard drive with it and it will show you the preview of the recovered data. If you are able to see your data through demo version then get the full version to save it.
Recover lost data
Hello!
Hopefully someone can help me that i have lost my data on my D: drive.
driven shown all folder but in side of the folder there is nothing.
i have lost my Doc, xls, Jpeg etc. all files.
please help me what sould i have to do.
thanks
This forum is specific to disaster recovery in SQL Server databases.
The standard answer is that you need to find your most recent backup and restore from it.
|||Don't worry you will get back your data. Try Stellar Phoenix Windows Data Recovery Software a file and parition recovery utility which recovers the lost data from formatted hard drive or data lost occur due to software malfunction, viruses or even sabotage.Download the demo version of the software from: http://www.stellarinfo.com/partition-recovery.htm Scan your hard drive with it and it will show you the preview of the recovered data. If you are able to see your data through demo version then get the full version to save it.
Subscribe to:
Posts (Atom)