ok i will check that thanks for reply

no i havent such error in log.

can you please explain what does it states?

give rights read and write to the share folder in the domain for the login id of the server and then try. you also consult your sysadmin for this

try to open share folder from the server where SQL Server is installed with login id which used to start the services of SQL Server hope this might help you.

thanks it worked.

try manually giving full access to the folder where sql file are there to id which the sql services are using to start. hope this may help.

i faced same issue...

oops my bad...

url itself the details i was saying about.. sorry..

hello,

url was very useful.Thanks.

one more i know is that suppose a new hard or cd drive in place in the system and your database drive letter changes then in sql...

i guess you are new to dba world... i gues you want to restore the backuped database on new server.

restore database databasename from disk ='filepath'

syntax might be different check Books...

Hello,

i found this in BOL

REPLACE performs comparisons based on the collation of the input. To perform a comparison in a specified collation, you can use COLLATE to apply an explicit...

thanks.. i will monitor the logs.

error says that you do have access on the c drive..

open cmd

type sqlcmd -S"servername" -U"username" -P"password"

after successful login you see

>1

1 use master

2 backup database dbname to disk=N'c:\foldername\db.bak'

3 go

the db backed...

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

use this link .

it shows to login and then once you login you write normal backup command

backup database dbname to disk='c:\db.bak'

Is your SQL Server is a Express edition

when you are inserting values in identity column

use

SET IDENTITY_INSERT schema_name.table ON

insert into schema_name.table(col1,col2.....)

select a,b,c... from table

SET IDENTITY_INSERT schema_name.table off

you have to explictly provide list of all columns n the...