Full Text Image Type

Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PraWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Pra" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Pra
>
>

Full Text Image Type

Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
Prasad
With
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>

Full Text Image Type

Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PrasadWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>

Full Database Back and Diffrential Database Backup

I have one full database back and 4 differential database backup.
(Recovery model is simple) In the recovery process, I have restored the
full database backup with No_recovery option. After that should i
restore all the 4 differential backup or the most recent differential
backup? Please explain.
RegardsHi
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting best practices
"Praveen" <apveen@.gmail.com> wrote in message
news:1143010815.337892.295070@.e56g2000cwe.googlegroups.com...
>I have one full database back and 4 differential database backup.
> (Recovery model is simple) In the recovery process, I have restored the
> full database backup with No_recovery option. After that should i
> restore all the 4 differential backup or the most recent differential
> backup? Please explain.
> Regards
>|||You have to restore first full backup and latest differential backup
you have taken after last full backup.
Regards
Amish Shah|||thank you for your replay. but i have a doubt. how only full database
backup and most recent diffrentail backup is enough to recover the
database?. why the intermediate diffrential backups are not required?.
Internally what is happening?.
BOL does not specify the backgroud process of recovery process while
applying the diffrential backup after full database back up?.|||Differential backups always store the changes from the last FULL backup. So
the previous Differential backups are not needed only the last one.
Andrew J. Kelly SQL MVP
"Praveen" <apveen@.gmail.com> wrote in message
news:1143029248.422816.10680@.j33g2000cwa.googlegroups.com...
> thank you for your replay. but i have a doubt. how only full database
> backup and most recent diffrentail backup is enough to recover the
> database?. why the intermediate diffrential backups are not required?.
> Internally what is happening?.
> BOL does not specify the backgroud process of recovery process while
> applying the diffrential backup after full database back up?.
>|||I got the answer from this link
http://msdn2.microsoft.com/en-us/library/ms345448(SQL.90).aspx
thanks for all.

Full Database Back and Diffrential Database Backup

I have one full database back and 4 differential database backup.
(Recovery model is simple) In the recovery process, I have restored the
full database backup with No_recovery option. After that should i
restore all the 4 differential backup or the most recent differential
backup? Please explain.
Regards
Hi
http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
--administaiting best practices
"Praveen" <apveen@.gmail.com> wrote in message
news:1143010815.337892.295070@.e56g2000cwe.googlegr oups.com...
>I have one full database back and 4 differential database backup.
> (Recovery model is simple) In the recovery process, I have restored the
> full database backup with No_recovery option. After that should i
> restore all the 4 differential backup or the most recent differential
> backup? Please explain.
> Regards
>
|||You have to restore first full backup and latest differential backup
you have taken after last full backup.
Regards
Amish Shah
|||thank you for your replay. but i have a doubt. how only full database
backup and most recent diffrentail backup is enough to recover the
database?. why the intermediate diffrential backups are not required?.
Internally what is happening?.
BOL does not specify the backgroud process of recovery process while
applying the diffrential backup after full database back up?.
|||Differential backups always store the changes from the last FULL backup. So
the previous Differential backups are not needed only the last one.
Andrew J. Kelly SQL MVP
"Praveen" <apveen@.gmail.com> wrote in message
news:1143029248.422816.10680@.j33g2000cwa.googlegro ups.com...
> thank you for your replay. but i have a doubt. how only full database
> backup and most recent diffrentail backup is enough to recover the
> database?. why the intermediate diffrential backups are not required?.
> Internally what is happening?.
> BOL does not specify the backgroud process of recovery process while
> applying the diffrential backup after full database back up?.
>
|||I got the answer from this link
http://msdn2.microsoft.com/en-us/library/ms345448(SQL.90).aspx
thanks for all.