i 've copied the data device and log device of the database before it was re
installed.
can i get the data back into the database ?? how so?
thanks in advance.
by giridha » Thu, 01 Jul 1999 04:00:00
can i get the data back into the database ?? how so?
thanks in advance.
by Kent Li » Thu, 01 Jul 1999 04:00:00
> can i get the data back into the database ?? how so?
>thanks in advance.
by Tibor Karasz » Thu, 01 Jul 1999 04:00:00
--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
> >i 've copied the data device and log device of the database before it was
> re
> >installed.
> > can i get the data back into the database ?? how so?
> >thanks in advance.
by giridha » Thu, 01 Jul 1999 04:00:00
>--
>Tibor Karaszi
>MCSE, MCSD, MCT, SQL Server MVP
>Cornerstone Sweden AB
>Please reply to the newsgroup only, not by email.
>> It is very easy, I've tried this for many times.
>> You can first create a new data device & log device file with same size
>and
>> then create a new database on these devices, then stop sql server and
copy
>> the old DAT files to cover new DAT files, and restart sql server to run
>dbcc
>> to ensure the data is ok.
>> >i 've copied the data device and log device of the database before it
was
>> re
>> >installed.
>> > can i get the data back into the database ?? how so?
>> >thanks in advance.
by giridha » Thu, 01 Jul 1999 04:00:00
i'dont know the device sizes,that were previously existing on the server ?
cant i get back data???
thanks in advance
by Christoph Muthman » Thu, 01 Jul 1999 04:00:00
After restore do a DBCC CHECKTABLE for every table. Follow the hints in the
BOL (Online Documentation) if you get any errors.
This should work for SQLServer 6.5.
Have a nice day,
Christoph
giridhar schrieb in Nachricht ...
Quote:> I've data device & log device , how to get dat back to a new database ,
>i'dont know the device sizes,that were previously existing on the server ?
> cant i get back data???
>thanks in advance
by Christoph Muthman » Thu, 01 Jul 1999 04:00:00
Sorry,
Christoph
Christoph Muthmann schrieb in Nachricht ...
Quote:>Hi giridhar,
>during restore you will get a warning with the minimum size the restore
>needs. Make your device than as big as you need it.
>After restore do a DBCC CHECKTABLE for every table. Follow the hints in the
>BOL (Online Documentation) if you get any errors.
>This should work for SQLServer 6.5.
>Have a nice day,
>Christoph
>giridhar schrieb in Nachricht ...
>> I've data device & log device , how to get dat back to a new database ,
>>i'dont know the device sizes,that were previously existing on the server ?
>> cant i get back data???
>>thanks in advance
by Tibor Karasz » Thu, 01 Jul 1999 04:00:00
--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
Quote:> I've data device & log device , how to get dat back to a new database ,
> i'dont know the device sizes,that were previously existing on the server ?
> cant i get back data???
> thanks in advance
1. i'dont know the device sizes, I've data device & log device , how to get data back to a new database
i 've copied the data device and log device of the database before it was re
installed.
can i get the data back into the database ?? how so?
i'dont know the device sizes,that were previously existing on the server ?
thanks in advance
2. dbexport
3. Data/Log devices on new Sun fast wide SCSI MultiPack don't work
5. Moving database from shared device to new device
6. contrib/tablefunc fixes (GRANTs to PUBLIC, use CREATE TYPE vice CREATE VIEW)
7. Altering a Database to log to a new Log Device
8. Simple, yet aggravating, problem with creating Interbase databases.
9. Can't move logging to a new device :-(
10. SA can't create db/log device
12. Data & Log Device Space Available