When you start SQL Server, it is the data file that is locked and not the folder.

When an instance is started, the master db is locked by the process of...

You don't happen to have an alias for that archive instance do you?

In services control panel, do you have the services for both instances running?

Yes - many records can impact performance.

If your primary activity is only against the most recent couple of years, then I would look to archive the data into a different...

I have done similar with the derived columns. That is what I would recommend.

the master database can only be used by one instance. Each instance would have its own master database.

Sometimes you may continue to see that index because the query that needs it has columns using a different sort order than the index. And sometimes it is a...

Lynn Pettis (3/10/2013)

---

It is possible that to improve system performance, you could more your nonclustered indexes to other file groups and have this file groups on separate spindles. This...

Did you say something ;-):-D

Please provide the exact script you used to backup the database via script.

TOY

Welsh Corgi (3/11/2013)

---

SQLRNNR (3/11/2013)

---

Jeff Moden (3/11/2013)

---

David Burrows (3/11/2013)

---

SELECT DISTINCT j.name as job_name,

msdb.dbo.agent_datetime(run_date, run_time) AS [run_datetime],

DATEADD(second,DATEDIFF(second,0,msdb.dbo.agent_datetime(19000101, run_duration)),msdb.dbo.agent_datetime(run_date, run_time)) AS [run_endtime]

FROM msdb..sysjobhistory h

INNER JOIN msdb..sysjobs j ON h.job_id = j.job_id

WHERE j.name...

Jeff Moden (3/11/2013)

---

David Burrows (3/11/2013)

---

SELECT DISTINCT j.name as job_name,

msdb.dbo.agent_datetime(run_date, run_time) AS [run_datetime],

DATEADD(second,DATEDIFF(second,0,msdb.dbo.agent_datetime(19000101, run_duration)),msdb.dbo.agent_datetime(run_date, run_time)) AS [run_endtime]

FROM msdb..sysjobhistory h

INNER JOIN msdb..sysjobs j ON h.job_id = j.job_id

WHERE j.name NOT LIKE 'Backup%'

AND...

I'd convert from maintenance plan backups and use script based backups.

But, even in the maintenance plan, you can type out the path for a UNC rather than rely on what...

You can take a backup to a UNC path \\server\share

If you run a manual backup for that database via script to that folder location, does it work?