SQL database back-up !!!!

[Kartik]

Can any1 tell me :-

while doing a database backup , Wat shud be done to ensure tat
this code-block :-
{
declare @strPath as varchar(250)
declare @strDate as varchar(15)

Set @strDate=(SELECT Convert(varchar(11),GetDate(),113)) --\'113 --- Format-For-Date\'
Set @strPath=\'C:\\SCHDBBackup\\SchDBBkup\'+@strDate+\'.bak\'


backup database sch to disk =@strPath
}

Does Not Append-with, BUT it overwrites the Existing database , @ the specified Path !

can we use {Export Data}{Import Data} available in Enterprise Manager ???

so, Tell me
r there many ways/options to do it ???

ALSO; suggest some Common practices/e-sites !!!

Thanx !

[sanereddy]

Karthik,

I would just use the Backup options available in the SQL Server Ent Manager, either you can do a one time backup right clicking on the database or create a Maintanace plan which backs up to the specified folder either complete or transactional which can be scheduled.

I will post more details on SQL Server and they will be added to our EFS Directory soon.

Hope this helps.
Thanks,

[Kartik]

Hello mr. Reddy !

Thanx a lot,

I now know
How to do SQL database backup by 2 Methods -
1. by all Tasks - Backup Database
2.Manage - Computer Management - Schedule a Job - Give the Timing for Daily/Weekly backup.

btw, Can u suggest some good e-books & Websites for SQL Server , plz ?

[sanereddy]

If you install SQL Server which is free download from Microsfot site and good for 4 months, it comes with full documentation you need for SQL Server...

you can check in http://www.itquestionbank.com for any articles and books

home this helps..

[rajk]

hi

This is first time i am posting a message

I am in urgent need to learn Sql server can anybody suggest an easy way to learn it with in 15 days.

And how can we store images in database for a website

Rajanik

[techguru]

Hello Raj,

You can store images to SQL Server... just download the eval copy from microsoft site, go though books online comes with the installation, you should be good in one week...

There is an image data type in SQL*Server. Images are backed up with the data. SQL Server has a utility called TEXTCOPY.EXE that allows to
read/write text and image data from SQL Server .Textcopy can be used for one image at a time If you need to do it in Bulk try the Bulk Insert Image (BII) Utility found in the Tools\Devtools\samples\utilities folder.

Delivering Web Images from SQL Server
http://www.microsoft.com/mind/0798/image.asp


Sample Chapter

Using Graphics Files with SQL Server

http://www.informit.com/guides/conte...eqNum=105&rl=1



Hope this helps,

[rajk]

Hi,


Thank for u help