gmamata7 (8/18/2010)

---

Hi,

We have performed the upgrade from SQL Server 2005 to SQL Server 2008 using Side-by-side upgrade method in a new server.

After the upgrade, we have changed the compatibility level...

Can you recreate...

pshaship (8/18/2010)

---

Hi,

We have a 2 node active/passive cluster setup for SQL Server 2005 x64 with SP3 on Windows 2003 x64 with SP2.

In order to perform maintenance on Active node, we...

shannonjk (8/17/2010)

---

Greetings all,

I have encountered this problem in the past, and today it reared its ugly head again in my Datawarehouse loads this morning. Basically what happened is a...

gmamata7 (8/18/2010)

---

Hi,

We have 2 node active/passive cluster setup for SQL Server 2005 SP3 on Windows 2003 x64 with SP2

A scheduled SQL Agent backup job has failed and after investigation,...

kd11 (8/13/2010)

---

When excuting this query below

SELECT *

FROM OPENQUERY( ADSI,

'SELECT Name, SN, ST

FROM ''LDAP://xxxx.local,DC=AAAAA4,''

WHERE objectCategory = ''Person'' AND

objectClass = ''user''')

I receive the error message:

Msg 7321, Level 16, State...

brownsea (8/13/2010)

---

Hi,

I has a user with 'SQLAgentOperatorRole' and 'TargetServersRole' permissions and it is db_owner in MSDB DB and it had EXECUTE permission on sp_start_job, but I am still getting the...

Patrick Womack (8/17/2010)

---

I'm planning for a disaster recovery scenario where our SQL Server 2005 Report Server crashes and I need to restore from the backup ReportServer and ReportServerTempDB files to...

backup locations are located in:

msdb..backupmediafamily

ejbatu1 (8/5/2010)

---

Alex thanks. The DB is backed up everyday at night. So if I understand you correctly does that mean once the DB is backed up, the system is...

This is normal if you have databases that are running long/big transactions.

run dbcc opentran to see which transactions are currently running.

Rebuilding/Reorganizing indexes will also increase the log if the log...

Did anyone figure out where backup locations are stored?

it's not in msdb..backupfile or msdb..backupset.

I'm looking for "D:\DBBACKUPS\test123_080520101200.BAK" after i execute:

backup database test123 to disk ='D:\DBBACKUPS\test123_080520101200.BAK'

Yes you can but i believe you must reinitialize subscriber after the upgrade.

Thank you for a fast response.

Did you use SQL Server Migration Assistant 2008 for Sybase ASE V4.0?

http://www.microsoft.com/downloads/details.aspx?FamilyId=4FC68B67-149F-4237-8869-E70B68947F4F&displaylang=en#AdditionalInfo

you cant create FTS on RBS but you can create fts on filestream.