Hi

Use "sqllitespeed" if you want to compress backup its much faster than taking backup and zipping.

Hi Venu

If you are restoring from a striped database backup then you will need to specify the name of all the members of the strip.

RESTORE DATABASE MyDatabase FROM

...

Ya

That doesn't mean i can't ask for help steve.

checkout might help

http://www.sqlservercentral.com/Forums/Topic367417-5-1.aspx

http://michael.omnicypher.com/2006/10/sql-server-2000-on-vista.html

YA might be.......

But what i want to Know is there anyway to find who , when and from where the 'sa' password was reset.

Have you also applied Service Pack 2 to both the Report Server and to the Development machine, and do you have the 'xxxxx' database installed.

Is it possible to avoid that particular page and do page restoration.

Can you tell me how to do page restoration.

Had checked the backup with

RESTORE.........VERIFYONLY

it gave a message

Msg 3189, Level 16, State 1, Line 1

Damage to the backup set was detected.

Msg 3013, Level 16, State 1, Line 1

VERIFY DATABASE...

Built-in functions that can return different data on each call are not allowed in user-defined functions. The built-in functions not allowed in user-defined functions are:

@@CONNECTIONS

@@PACK_SENT

GETDATE

@@CPU_BUSY

@@PACKET_ERRORS

GetUTCDate

@@IDLE

@@TIMETICKS

NEWID

@@IO_BUSY

@@TOTAL_ERRORS

RAND

@@MAX_CONNECTIONS

@@TOTAL_READ

TEXTPTR

@@PACK_RECEIVED

@@TOTAL_WRITE 

Check out these

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30834/[/url]

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31605/[/url]

error: Cannot use the special principle 'sa'.

Are you use Windows authentication, if so sa is disabled by default.

Use "Mixed Mode" authentication.

You can Import the excel sheet as a table to a database using import and Export Wizard.

Check out this link:

http://msdn.microsoft.com/en-us/library/ms140052(SQL.90).aspx

Hi

Can you tell what is the error.

Hi while creating the view you can use CHECK_OPTION to prevent insert and update option.

Check out the example:

http://www.rampant-books.com/t_super_sql_129_check_option_view.htm

resource_type = object

Represents a database object. This object can be a data table, view, stored procedure, extended stored procedure, or any object that has an object ID.

check this ...