hi

for always restoration, check the property back of extension like .bak

and location of path u can easily identify and restore the db

Goodluck

KingManjunath

hi

there are lot more ways to transfer table from one instance to another instance.

1.import and export

2. run script on source instance, copy and excute the same script on other instance

3.bcp

4....

hi

when the sp which contains the query on a particular table is taking much time to excute it may has several reasons

first see the blocking issues on that query or...

hi,

better move the dbs on offline because u r not going to get any errors,

Goodluck

KingManjunath

hi

try to configure, only the min mermory on sql server not max momery, sql server dynamically takes from os whenever required and after finishing the job, it leaves dynimically for...

hi,

better not taking backups on the same disk where the server is , if it is on the other network place, it will be esier to refresh the backup, when...

hi,

use SSIS to move a database from 2000 to 2005. and also u use this for other tasks to backup, transfer logins, jobs etc.

Goodluck

Manjunath

hi,

delete unwanted log files those before the full backup taken.

Goodluck

Manjunath

hi,

better use third party tools like litespeed, its in build shrinked and backed up instead of going in the traditional way.

Goodluck

KingManjunath

hi,

if you are moving or attaching sytem dbs, along with you need to move the resource db to the master db location.

Goodluck

KingManjunath

Hi Savitha,

The named instance is the instance where you have given the specific name to SQL server Installation after the default instance, you can create upto 49 named instances in...

hi,

yes, it's required sometimes checking the event viewer, because event viewer records every movement happed at os level, you need go though the sites first to understand the errors.

Goodluck

KingManjunath

hi,

If everything works fine without indexes your work is easy enough, but later if the huge data is inserted or updated, your db performance will be slower if no...

Hi,

Are you just moving the master db on the different location, or renbuilding the master db?

If you are just moving the master db, you need to first concentrate on the...

hi

try using the stored proc 'exec sp_trace_setstatus

manz