Hi,

Trust this http://www.sqlservercentral.com/Forums/Topic872933-146-1.aspx#bm872990 will help

Thnaks,

Mohammed

Hi,

Trust this http://www.sqlservercentral.com/Forums/Topic872933-146-1.aspx#bm872990 will this help.

Thanks,

Mohammed

Hi,

Could you please let know 'what was the action done'

Thanks,

Mohammed

Hi,

Shrinking a SQL 2005 DB or above will not break the Logshipping.

Thanks,

Mohammed.

didi77 (8/6/2012)

---

So on my sql test server,

I create a quick logshipping, with a data base witch have already a hudge LDF file.

I made a tsql backup log like that :...

Hi,

It would be better if we ignore the fragementation of indexes with less than 1000 pages

Please refer below URL:

http://connect.microsoft.com/SQLServer/feedback/details/244214/index-rebuild-doesnt-affect-fragmentation

Hope the URL clarifies your doubt 🙂

Thanks,

Mohammed

Hi,

Could you be please more specific on the query.

Are you planning for upgrading from SQL SERVER 2008R2 DEVELOPER EDITION TO SQL SERVER 2008 R2 ENTERPRISE EDITION..?

Thanks,

Mohammed.

Hi,

Assuming the issue is with the standalone server,

Please check whether the reporting services is started or not in services.msc..?

Thanks,

Riyaz

Hi Pradeep,

You may not be able to mirror 1000 databases to DR site.,

Because,

On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance...

Hi Ahmed,

Assuming the issue is with a single database,

Please ask the DBA to add your login to db_backupoperator role which is existed on the database.

Thanks,

Mohammed

Hi,

When SQL Server 2000 and SQL Server 2005 clients request SQL Server resources on a named instance, the client network library sends a UDP message to the server using port...