Thanks a lot Steven and Gila to help me get these things done.

thanks a lot , you guys rock

Thanks Gila I did backed up my data but not the log, hope...

Steve Jones - SSC Editor (4/22/2013)

---

If you're loading 1-2 GB a day in the log, I'd shrink the log to 5GB. Space is relatively cheap, and this gives you pad.

You...

error

Msg 3201, Level 16, State 1, Line 1

Cannot open backup device '\\X\analyitcs\test_UNC.BAK'. Operating system error 53(The network path was not found.).

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is...

I tried couple of UNC but I am not getting it correct :

I have an x drive mapped to it , what should be the correct UNC?

first I have to run log backup by taking it offline and then use backup option in SQL mgmt studio.

the challenge here is that the sql server is on remote...

C drive : 200gb

sql log: 140 gb

sql data : 30 gb

etc : 10-20gb

space left : less than 5gb

logs increments 1.5- 2gb a day

Thanks Steve and Gila.

if this is organization data what would you prefer ?

My first requirement will be to have space in drive

2nd recover when needed

so in my case , I just need data to be restored by months but main emphasis it get space on my drive.

so which backup should I be using and...

My data gets updated daily once.

I need more space in disk and historical data changes is not necessary because i can use backup to create them back again ( ...

VIJI,

I am new to SQL but i am going to try your advice.

1) how stop all current transaction to that DB (let my db name be Analytic)

2) after taking...