you need to create the linked server first.

then using linkedservername.databasename.dbo.tablename

you can select/alter/create if the account have enough permission which you configured on linked server to connect

remove primary key and auto increment value.

Rest them to 10 20 30 and assign back the primary key and auto increment

what do you mean by schedule the job continuously?

The job will automatically run on its next schedule if your job agent(sqlserveragent) is running

restoring 86 gb on the server with 16gb of RAM should not be problem if, scheduled at the correct time when server is idle.

you can still do it by using log shipping. As its mainly used for reporting, it means database can be set to read only on secondary server and log can...

First of all why you are restoring database daily? You can configure log shipping for this or mirroring.

Also I am not able to understand what you mean by server size...

1) Do you have disk space issue on that server?

2) Is the issue you gwetting on a specific query or any simple select statement as well?

3) Which version of sql...

is this error you getting in some of your scheduled job and running queries?

If its on running queries then have you checked the bandwidth limitation with the server as well...

yes why not.

Its just name and you need to decide which one to be primary and which one to be secondary.

At any point of time, you can switch...

what do you mean by database template?

Model itself is default template for any new database.

new domain, new security.

You need to configure some windows account which have the admin permission on domain and then that can be used to run the services.

Later on same...

1) change the database back to operation mode

2) restore the latest log with recovery.

3) once your primary up, then if you wish you cna put secondary back to read only.

ashish.kuriyal (9/6/2010)

---

try to change maintenance plan to delete last 2 days file its 1 day as of now or just add one more day. And then once it run successfully...

1) create a group and assign all the suers in that group.(It will be easy for your to manage)

2) go to that perticular SP, right click and select properties. Go...

i think with this statement, everytime, you will get new value

set @CheckDate = replace(replace(convert(nvarchar(50),getdate(),120),':',''), ' ', '_')