[font="Verdana"]Writing Certifications with the help of dumps is mere waste, since you are studying to upgrade your knowledge on the respective field. If you go for certification with the help...

Hi Madhu,

For tempdb you don't need to move the physical files since tempdb will be created each time when SQL services gets restarted hence execute ALTER DATABASE command for tempdb.

Model...

Make use of copy database wizard to do this.. Refer the link below

How to use Copy Database Wizard

Can you run RESTORE VERIFYONLY on the backup file?? Can you post all the error message you are receiving?? Can you try in GUI??

I don't think so its needed! Why your master database in older compatibility level?? Have you upgraded SQL Server to SQL 2005??

You can try the below query to detach all the user databases.

Detach All User Databases

I hope you won't loose any transactions since when you stop sql server all the uncommitted...

Hi Mike,

10MB growth for a 30GB database is too low, try setting the autogrow value to 5%.

Is there any bulk insert or DBCC running on the database?

Try the below command via linked server

exec msdb..sp_get_composite_job_info @execution_status =1

Yes I agree with Mike, tempdb might be installed in C: drive, move it to D: drive. Refer the below article for the same.

Moving system db's

Hi,

Welcome to SQLServercentral 🙂

SQL Server 2005 supports password policy for SQL Logins, can you check whether the login used through applicaiton is enabled for password policy??

Check any Orphan Id's present...

Yes you can edit the maintenance plan and click on log button and change the path where you need to store the logs!

Hi,

You can try the below query. I'm connecting to the localserver using windows authentication

bcp ASPT.dbo.tablename in A.dat -T -c

Please note that you need to provide the table name to import...

Hi,

You can configure mirroring in asynchronous mode, so that when the link between principal and mirror disconnects failover won't automatically happen and when the connection reestablishes transactions from primary will...

[font="Tahoma"]Hi Shailesh,

If you are working with SQL Server 2005 then you can make use of DDL triggers to capture the details you have mentioned above. This will be simple and...

[font="Verdana"]Hi,

In this case since default instance doesn't exist in the server, and sql browser service will allocate dynamic port to sql service and hence when you use the servername it...