@ sql buddy..

The drive has 420GB free space if i delete that 144GB .bak file...but thing is that

when i delete that .bak file and then restore it through SSMS...

@sqlbuddy....

The data files for that database are on other server 307GB(mdf) and 10GB(ldf)..

locally i just have the .bak file which is 144GB and free space left is 271GB..

1) I...

Hi,

What do you mean by " log shipping “works” but the Restore job doesn’t restore anything. It doesn’t pick up the file."

how can then log...

Hi,

I had to do the same thing before few days. I tried to do that by copy database wizard in 2005 and it was faulty.

I heard...

hi,

When i tried to restore the file from locally, it says there is insufficient space on the drive. I have 271 GB free space left on...

Hi,

we had the similiar kind of issue, It was because the sql domain account in AD from which all sql services was running, it got locked...

SQL DBA + SSIS + MS Dynamics GP

Good paid job...

🙂

Sushant

DBA

BVI

Please check the maintenance plan.

Edit the maintennace cleanup task and see the folder u r tryin to delete it from.

is it correct ,also check hte extension and

select the...

For editing a job, you dont need to restart sql server agent

ya i know that

maintenance plan has a notify operator task .

but the thing is dat I am getting messages if job is successful also.

In that I have enabled that...

Hi,

@malleswara, this step did the trick:-

EXEC sp_addlinkedsrvlogin 'SF-PC035', 'false', NULL, 'sa', 'password'

Thanks all,

Sushant

@ malleswara.....I already added tht 2nd server as linked server

@steveb-2 I guess ..The 2nd server(PRY2) has different sa password...so where should I put it in the query?? or...

select dbo.POP10100.PONUMBER,

dbo.POP10100.VENDORID,

dbo.POP10100.VENDNAME AS VENDORNAME,

dbo.POP10100.DOCDATE AS DOCUMENTDATE,

dbo.POP10100.PRMDATE AS PROMISEDDATE,

dbo.POP10100.REMSUBTO AS REMAININGSUBTOTAL,

dbo.POP10100.HOLD,

dbo.POP10100.BUYERID AS BUYER,

dbo.POP30300.POSTEDDT AS GPPOSTEDDATE,

dbo.IV10200.DATERECD AS RECEIPTDATE,

dbo.IV10200.RCPTNMBR AS RECEIVERNUMBER

from dbo.POP10100

JOIN dbo.POP30300

ON

dbo.POP10100.VENDORID = dbo.POP30300.VENDORID

JOIN [xxx-xxx-PRY2].[InventoryData].dbo.[IV10200] PR

ON dbo.POP10100.VENDORID = PR.VENDORID

where dbo.POP10100.VENDORID not...

In the BVI (british virgin islands)

near carribean islands (west indies)

see this if u can get any help:-

http://dbaspot.com/forums/sqlserver-faq/384103-upgrade-sql-2005-developer-standard.html